SQL interview questions: CTEs JOINS and multiple Groupings SQL practice for Data Analysts

In this second video of my SQL series, we dive into the logic behind an Intermediate SQL query from HackerRank; using CTEs, multiple aggregations and GROUP BYs, and a pretty simple JOIN of our Common Table Expression (CTE) to the original table to get our final output.

00:00 Introduction
00:35 Reviewing the Question
01:04 Start Coding
01:54 Finding MAX score
03:00 GROUP BY challenges
04:52 Creating a CTE
05:19 Getting Total score
07:05 HAVING
07:55 ORDER BY Tip
08:28 Order of Operations
09:09 Why HAVING Wont Work
10:23 Fix the HAVING
11:43 Final Query
The best way to get better is by doing... That goes for YOU learning SQL, and for ME making more videos.

👉 Subscribe for more!

Don’t hesitate to leave constructive feedback in the comments! Your input helps me grow. 😉
HackerRank Question from the video:
https://www.hackerrank.com/challenges/contest-leaderboard/problem?isFullScreen=true
LinkedIn: https://www.linkedin.com/in/cameron-css/

Видео SQL interview questions: CTEs JOINS and multiple Groupings SQL practice for Data Analysts канала CamCodes