The Uncharitable Ranking | Intermediate SQL Problem
In this video we write a SQL query with an interesting twist on ranking. Along the way, we review the basics of the ROW_NUMBER, RANK, and DENSE_RANK window functions.
Video chapters
00:00 - Problem description and set-up
03:52 - Review of ranking window functions
07:46 - Choosing the right ranking function
08:50 - Starting to construct the solution
11:21 - Fixing the ranking numbers
18:12 - Final thoughts and outro
If you would like to follow along at home and have a crack at solving this problem:
Local environment set-up instructions are in the Write a SQL Query GitHub repo README: https://github.com/cedwards036/write-...
The problem set-up code for today's episode can be found here: https://github.com/cedwards036/write-...
Thumbnail art and channel logo: FriezerBurnt https://www.friezerburnt.com/
Recording set up:
Database: PostgreSQL run locally in a docker container
SQL client: DBeaver https://dbeaver.io/
Microphone: Samson Q2U https://samsontech.com/products/micro...
Recording software: OBS https://obsproject.com/
Thank you for watching! Leave a comment below if you can think of any alternate solutions to today's problem, have suggestions for future videos, or just like to chat. Happy querying!