SQL Interview Questions

Practice 180 online SQL coding questions and ace your data job interview.

Nervous about your SQL interview? Try instamentor and hire a FAANG mentor for 1:1 job interview coaching.

ALL QUESTIONS

Affirm SQL Interview Questions Airbnb SQL Interview Questions Afterpay SQL Interview Questions Amazon SQL Interview Questions Doordash SQL Interview Questions Dropbox SQL Interview Questions Ebay SQL Interview Questions Facebook SQL Interview Questions Google SQL Interview Questions Linkedin SQL Interview Questions Lyft SQL Interview Questions Robinhood SQL Interview Questions Spotify SQL Interview Questions Tiktok SQL Interview Questions Uber SQL Interview Questions Walmart SQL Interview Questions

Window Functions: Lecture 2: ROW_NUMBER, RANK, DENSE_RANK
ID Title Level FTPR Lecture
62 Shortest film by category medium
9%
4.2
63 Top 5 customers by store hard
5%
4.2
64 Top 2 films by category hard
11%
4.2
72 Days when they became happy customers easy
15%
4.2
73 Number of days to become a happy customer medium
10%
4.2
74 The most productive actors by category hard
7%
4.2
75 Top customer by movie category medium
21%
4.2
76 Districts with the most and least customers easy
12%
4.2
83 Top search_query in US and UK on new year's day facebook medium
8%
4.2
88 Top song report spotify medium
25%
4.2
90 Top artist report spotify medium
11%
4.2
105 Number of days gap between last two actions google hard
20%
4.2
109 Top 3 most popular product categories amazon easy
18%
4.2
110 Most popular product by category amazon medium
15%
4.2
116 Top answers day by device amazon easy
27%
4.2
119 Top 3 countries by bookings airbnb hard
11%
4.2
120 First ever booking airbnb hard
13%
4.2
122 Top 3 countries by wow growth airbnb hard
33%
4.2
123 Top 10 listings in Australia, United Kingdom and Canada airbnb medium
20%
4.2
127 Average rating after 10th trip uber hard
0%
4.2
135 Unlucky employees robinhood easy
0%
4.2
137 Extremely late first orders doordash medium
33%
4.2
139 Poor first delivery experience doordash medium
100%
4.2
142 First order date afterpay easy
0%
4.2
144 Third order afterpay medium
100%
4.2
145 Returning customers after first buy afterpay hard
50%
4.2
148 Most popular video category tiktok medium
50%
4.2
157 Number of trips before a driver got banned lyft medium
100%
4.2
158 First trip completion rate lyft medium
100%
4.2
165 Session stitching walmart hard
50%
4.2
166 Top 10 customers based on spend growth google medium
20%
4.2