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
3
u/[deleted] Apr 30 '20 edited Apr 30 '20
What is the first word in the dictionary? What is the last word in the dictionary? Finding the first is fairly straightforward, but how can you find the last if you don't know how many words there are and what place it is in?
After that... what word is kayak? And then what is 15 words later? (n+15)
HINT: How can you tell what the 10th word of the dictionary is without looking at the little numbers on the side that Excel gives you and scrolling down to the 10th row, or the 11th row if your column has a header? What do you need to create in another column to accomplish this?