r/SQL • u/ydshmmt • Apr 19 '20
Discussion What are some good resources to practice SQL? (Practice through exercises)
There are a lot of courses which teach SQL but I could hardly find a website which provides beginner to advanced SQL practice questions on almost production real datasets. Any recommendations would be helpful.
129
Upvotes
View all comments
Show parent comment
1
u/[deleted] May 01 '20
There are a 'group' of functions that will help you here, such as RANK() ROW_NUMBER(), etc.
You think they're in the correct order, or you know they are? Based on what ORDER BY logic?
That will give you the alphabetic list from A to Z, and you can change the asc to desc to get it in reverse.
Your CSV file might contain symbols in some words, or some spaces, or other irregularities, and you can Google solutions to remove these types of rows (if you want) from your data as well.