A fun little problem with Tuples where you shouldn’t over think the execution of this. Less code is better! Note, I’ve noticed that nothing actually works in Python 3, so stick to PyPy3 instead for this question. While this isn’t harder than any particular SQL,… Continue Reading
Machine learning (ML) is growing in popularity, and with it – languages like R and Python have also exploded in usage and adoption. That being said, it’s incredibly hard to start a career in machine learning due to how many skills you need. A machine… Continue Reading
Another interesting query, with very unique criteria that you need to pay attention to. There’s multiple was you can attack this, but the most common way seems to be creation of a CTE, VIEW or function and using ROW_NUMBER(), PARTITION() to help number and organize… Continue Reading
A great SQL problem, that needs a high level of attention to detail. This problem is not as technically complicated as some of the previous problems like Draw the Triangle 1 or Draw the Triangle 2. The use of CONCAT is advised for this challenge,… Continue Reading
A slightly more difficult solution, Hackerrank draws on it’s previous question in of Draw the Triangle 1, with Draw the Triangle 2. Let’s jump into it. The problem P(R) represents a pattern drawn by Julia in R rows. The following pattern represents P(5): Write a query to print the… Continue Reading
Another really interesting SQL Hackerrank problem, which forces you to break down a problem and build a procedure. While I know there are multiple ways to handle this problem (like most), I feel like this way allows you to flex multiple skills and try out… Continue Reading
Here’s a quick an easy SQL Hackerrank solution for one of the last “aggregate” courses. It’s an interesting one because you can end up overthinking your approach. The problem We define an employee’s total earnings to be their monthly salary x months worked, and the maximum total earnings to be… Continue Reading
Hey there, while I grow my Python skills – I found this one specific issue to be very challenging. However, my solution is much different from the other ones online, and also works for inputs! The problem Given the participants’ score sheet for your University… Continue Reading
This was a really fun question, with a lot of moving parts. It tests your knowledge of basic statistics, while also looking to see if you can use multiple functions. The Question A median is defined as a number separating the higher half of a data set… Continue Reading
Hi there! Here’s my solution for the Hackerrank Python introduction for If-else! Ultimately, this an interesting test of basic Python conditionals, while providing a level of difficulty that is around EASY. Note: In Hackerrank, I moved around the n variable input since if it’s nested… Continue Reading
