The Uncharitable Ranking | Intermediate SQL Problem

Publié le: 04 février 2025
sur la chaîne: Write a SQL Query

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!

Sur cette page du site, vous pouvez voir la vidéo en ligne The Uncharitable Ranking | Intermediate SQL Problem durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Write a SQL Query 04 février 2025, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 39 fois et il a aimé 3 téléspectateurs. Bon visionnage!

10,964

123