Joins, joins, joins – nothing but joins! Four tables that need to be joined together and uniquely filtered for specific things. Really think about how you want to structure your joins as if you’re joining. While this was not as hard as occupations, it’s easier… Continue Reading
A great question with the need to do multiple joins or pivot the data. Don’t overthink this one as it can get messy if you decide to try to do PIVOT or GROUP(CONCATENATE). What I learned from this problem is, you can Google or ChatGPT… 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
As we continue to navigate the challenges of the pandemic, online classes have become a necessary part of education, and online presentations are an essential part of the learning experience in online classes. Creating an engaging and informative animation presentation can be challenging, but it… 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
