This solution was fun to solve. It has it all, loops, conditionals, string manipulation, variables and functions. While you may be able to use the function swapcase(), I think it’s a great way to show Jr. Python developers how to mix everything together! While it… Continue Reading
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
If you are looking to learn Java (the programming language not coffee 🙂 ), there is no better place than Udemy. With an array of top-notch tutorials, projects and apps to build in the platform, it’s easy to find a java course that suits your… Continue Reading
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
