SQLPad SQLPad Sign In

SQL Coding Questions & Answers

Practice 216 online coding questions and become a data expert.

ALL QUESTIONS

Affirm SQL Interview Questions Afterpay SQL Interview Questions Airbnb SQL Interview Questions Amazon SQL Interview Questions Doordash SQL Interview Questions Dropbox SQL Interview Questions Ebay SQL Interview Questions Google SQL Interview Questions Linkedin SQL Interview Questions Lyft SQL Interview Questions Netflix SQL Interview Questions Robinhood SQL Interview Questions Roblox SQL Interview Questions Snap SQL Interview Questions Spotify SQL Interview Questions Tiktok SQL Interview Questions Twitter SQL Interview Questions Uber SQL Interview Questions Visa 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
8%
4.2
64 Top 2 films by category hard
16%
4.2
72 Days when they became happy customers medium
10%
4.2
73 Number of days to become a happy customer hard
11%
4.2
74 The most productive actors by category hard
11%
4.2
75 Top customer by movie category medium
28%
4.2
76 Districts with the most and least customers easy
11%
4.2
83 Top search_query in US and UK on new year's day search engine medium
6%
4.2
88 Top song report spotify medium
23%
4.2
90 Top artist report spotify medium
22%
4.2
105 Number of days gap between last two actions mobile hard
9%
4.2
109 Top 3 most popular product categories amazon easy
11%
4.2
110 Most popular product by category amazon medium
11%
4.2
116 Top answers day by device amazon easy
14%
4.2
119 Top 2 countries by bookings airbnb hard
6%
4.2
120 First ever booking airbnb hard
7%
4.2
122 Top country by wow growth airbnb hard
8%
4.2
123 Top listing in the United States, United Kingdom and Canada airbnb medium
8%
4.2
127 Average rating after 10th trip uber hard
11%
4.2
135 Unlucky employees robinhood easy
15%
4.2
137 Extremely late first orders doordash medium
7%
4.2
139 Poor first delivery experience doordash medium
14%
4.2
142 First order date afterpay easy
34%
4.2
144 Third order afterpay medium
10%
4.2
145 Returning customers after first buy afterpay hard
15%
4.2
148 Most popular video category social medium
12%
4.2
157 Number of trips before a driver got banned lyft medium
5%
4.2
158 First trip completion rate lyft medium
21%
4.2
165 Session stitching walmart hard
15%
4.2
166 Top 10 customers based on spend growth walmart medium
13%
4.2
188 Top 1 popular question by department google hard
100%
4.2
201 Top 3 students for each subject snap medium - 4.2
203 Top 5 products by country by month search engine easy - 4.2
208 Top 3 urls by testing groups search engine medium - 4.2

Industry/company specific questions are sourced over the internet, however, we cannot guarantee 100% accuracy of the information provided. We strongly advise users to exercise their discretion when using the platform. By using SQLPad, you acknowledge and agree to our terms.