LeetCode 178: Rank Scores [SQL]

Solution and walkthrough of leetcode database problem 178: Rank Scores I'm using MySQL but this solution should work in any SQL dialect such as PostgreSQL SQL Server, etc.
Link to the problem: leetcode.com/p...
Check out my StrataScratch videos: • StrataScratch Coding Q...

[@frederikmuller]

If you want to have access to more free SQL problems, check out StrataScratch: stratascratch.com/?via=frederik

[@BluEN1111]

select a.score, count(DISTINCT b.score) as "Rank" from Scores a join Scores b
on a.score

[@avahome5285]

NOTES:Rank will produce 1,1,3; Dense Rank produce 1,1,2

[@frederikmuller]

exactly

[@herdata_eo4492]

thanks for this

[@dkseo1992]

I love the second you explained. Thank you!

[@ajaxaj6749]

Love the second explaination.

[@sheharyarkhan5500]

learned a lot in this actually!!! (concept of separating table and comparison)
thank you for your content

[@Apocalypse-vp3kg]

Solution 2 is good for me🐱

[@chloewei768]

Thank you!! Great video!

[@ragnarlodhbrok1684]

how count function works without group by clause ....please explain,very confused...

[@shreyagrawal3806]

Helpful video

[@davidwang8971]

why newly created column rank should be added with " "? thx!

[@sujitamin949]

well explained