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
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
Here’s a cool problem from HackerRank that’s specifically centered around JOINING and CASE usage. I used specifically MySQL to solve this problem! The Problem You are given two tables: Students and Grades. Students contains three columns ID, Name and Marks. Grades contains the following data: Ketty gives Eve a task to generate a report containing three columns: Name, Grade and Mark. Ketty doesn’t want… Continue Reading
