SQLPad
Sign In

SQL Coding Questions & Answers

Practice 216 online coding questions and become a data expert.

ALL QUESTIONS

affirm afterpay airbnb amazon doordash dropbox ebay google linkedin lyft mobile netflix robinhood search engine snap social spotify tiktok twitter uber visa walmart

ID Title Level FTPR Lecture
1 Top store for movie sales easy
30%
2.1
2 Top 3 movie categories by sales easy
47%
2.1
3 Top 5 shortest movies easy
53%
2.1
4 Staff without a profile image easy
67%
2.1
5 Monthly revenue easy
24%
2.2
6 Daily revenue in June, 2020 medium
11%
2.2
7 Unique customers count by month easy
19%
2.2
8 Average customer spend by month easy
22%
2.2
9 Number of high spend customers by month medium
4%
2.2
10 Min and max spend easy
13%
2.2
11 Actors' last name easy
24%
2.3
12 Actors' last name ending in 'EN' or 'RY' easy
30%
2.3
13 Actors' first name medium
13%
2.3
14 Good days and bad days hard
4%
2.3
15 Fast movie watchers vs slow watchers hard
5%
2.3
16 Staff who live in Woodridge easy
72%
2.1
17 GROUCHO WILLIAMS’ actor_id easy
65%
2.1
18 Top film category easy
25%
2.2
19 Most productive actor medium
14%
2.2
20 Customer who spent the most medium
15%
2.2
21 Customer who rented the most medium
20%
2.2
22 Average cost per rental transaction easy
43%
2.3
23 Average spend per customer in Feb 2020 easy
16%
2.2
24 Films with more than 10 actors medium
20%
2.3
25 Shortest film easy
46%
2.3
26 Second shortest film easy
29%
2.3
27 Film with the largest cast easy
27%
2.3
28 Film with the second largest cast medium
25%
2.3
29 Second highest spend customer medium
16%
2.3
30 Inactive customers in May easy
21%
2.3
31 Movies that have not been returned easy
27%
2.3
32 Unpopular movies hard
16%
2.3
33 Returning customers medium
8%
2.3
34 Stocked up movies easy
28%
2.3
35 Film length report easy
26%
2.3
36 Actors from film 'AFRICAN EGG' easy
36%
3.1
37 Most popular movie category easy
17%
3.1
38 Most popular movie category (name and id) medium
18%
3.1
39 Most productive actor with inner join easy
23%
3.1
40 Top 2 most rented movie in June 2020 medium
15%
3.1
41 Productive actors vs less-productive actors hard
6%
3.2
42 Films that are in stock vs not in stock medium
11%
3.2
43 Customers who rented vs. those who did not medium
9%
3.2
44 In-demand vs not-in-demand movies medium
6%
3.2
45 Movie inventory optimization hard
7%
3.2
46 Actors and customers whose last name starts with 'A' easy
32%
3.3
47 Actors and customers whose first names end in 'D'. easy
45%
3.3
48 Movie and TV actors easy
43%
3.1
49 Top 3 money making movie categories medium
19%
3.1
50 Top 5 cities for movie rentals easy
23%
3.1
51 Movie only actor easy
43%
3.2
52 Movies cast by movie only actors easy
13%
3.2
53 Movie groups by rental income hard
11%
3.2
54 Customer groups by movie rental spend medium
21%
3.2
55 Busy days and slow days medium
11%
3.2
56 Total number of actors easy
32%
3.2
57 Total number of actors (with UNION) easy
37%
3.3
58 Percentage of revenue per movie hard
8%
4.1
59 Percentage of revenue per movie by category medium
7%
4.1
60 Movie rentals and average rentals in the same category hard
9%
4.1
61 Customer spend vs average spend in the same store hard
12%
4.1
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
65 Movie revenue percentiles easy
16%
4.3
66 Movie percentiles by revenue by category medium
19%
4.3
67 Quartile by number of rentals easy
24%
4.3
68 Spend difference between first and second rentals hard
12%
4.4
69 Number of happy customers hard
12%
4.4
70 Cumulative spend easy
14%
4.1
71 Cumulative rentals easy
18%
4.1
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
77 Movie revenue percentiles by category easy
20%
4.3
78 Quartiles buckets by number of rentals medium
23%
4.3
79 Spend difference between the last and the second last rentals hard
18%
4.4
80 DoD revenue growth for each store hard
19%
4.4
81 How many people searched on new year's day search engine easy
24%
2.2
82 The top search query on new year's day search engine easy
12%
2.2
83 Top search_query in US and UK on new year's day search engine medium
6%
4.2
84 Click through rate on new year's day search engine medium
10%
2.2
85 Top 4 queries based on click through rate on new year's day search engine hard
6%
2.2
86 Top song in the US spotify easy
19%
2.2
87 Top song in the US and UK spotify medium
10%
3.3
88 Top song report spotify medium
23%
4.2
89 Top 5 artists in the US spotify medium
11%
2.2
90 Top artist report spotify medium
22%
4.2
91 same day friend request acceptance rate spotify easy
11%
3.1
92 Acceptance rate first week of 2021 spotify easy
14%
2.1
93 number of sales for each product this month amazon easy
19%
2.2
94 Top 3 products vs. bottom 3 products amazon medium
6%
3.3
95 Candidate products for subscription amazon hard
11%
2.2
96 Overall acceptance rate social easy
13%
2.2
97 Social influencer social easy
10%
2.2
98 Most popular user social easy
29%
2.2
99 Page recommendation social medium
12%
3.1
100 Advertiser ROI social medium
9%
3.2
101 Average number of visits per user mobile easy
12%
2.2
102 Histogram by visit session duration mobile hard
12%
2.3
103 Median and average session duration by day of the week mobile medium
17%
4.3
104 MAU: Monthly active users mobile easy
19%
3.3
105 Number of days gap between last two actions mobile hard
9%
4.2
106 Mobile vs. web mobile medium
9%
2.2
107 Customer count by platform mobile medium
19%
2.2
108 Free premium membership amazon hard
17%
4.1
109 Top 3 most popular product categories amazon easy
11%
4.2
110 Most popular product by category amazon medium
11%
4.2
111 Second most popular product amazon medium
14%
2.1
112 Top 3 customers amazon easy
30%
2.2
113 Daily cumulative spend amazon easy
9%
4.1
114 Dod revenue change rate amazon easy
13%
4.4
115 Rolling average revenue amazon hard
26%
4.1
116 Top answers day by device amazon easy
14%
4.2
117 Rolling 7 days total answers amazon easy
35%
4.1
118 Daily bookings in the US airbnb hard
5%
3.2
119 Top 2 countries by bookings airbnb hard
6%
4.2
120 First ever booking airbnb hard
7%
4.2
121 Week over week change of first ever bookings airbnb hard
6%
4.4
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
124 Active restaurants by city uber easy
36%
2.2
125 Active restaurants with fewer than 5 trips per city uber easy
14%
2.2
126 Top 3 restaurants uber hard
9%
2.1
127 Average rating after 10th trip uber hard
11%
4.2
128 Completion rate uber easy
23%
2.2
129 Top 3 and bottom 3 courier uber medium
10%
3.3
130 Newly created accounts affirm easy
34%
2.2
131 Churned accounts affirm hard
10%
2.3
132 Top 3 trending countries affirm medium
8%
2.2
133 Small departments robinhood easy
44%
2.2
134 Expensive departments robinhood medium
32%
2.2
135 Unlucky employees robinhood easy
15%
4.2
136 Extremely late orders doordash easy
5%
2.3
137 Extremely late first orders doordash medium
7%
4.2
138 Happy restaurants doordash easy
10%
2.3
139 Poor first delivery experience doordash medium
14%
4.2
140 Daily sales of restaurant 100011 doordash hard
9%
3.2
141 Cumulative sales of restaurant 100011 doordash hard
16%
4.1
142 First order date afterpay easy
34%
4.2
143 Customer purchase report afterpay easy
15%
2.2
144 Third order afterpay medium
10%
4.2
145 Returning customers after first buy afterpay hard
15%
4.2
146 Purchase by platform afterpay easy
13%
2.2
147 2 days streak customers social hard
11%
4.4
148 Most popular video category social medium
12%
4.2
149 fans by video category social easy
30%
2.2
150 Countries with above average customers social easy
10%
3.1
151 Salary report dropbox easy
16%
2.3
152 Salary analysis dropbox easy
23%
2.1
153 Project ROI dropbox easy
18%
2.2
154 Rideshare completion rate lyft easy
22%
2.2
155 Driver with the highest cancellation rate lyft easy
22%
2.3
156 Cancellation rate by unbanned users lyft hard
14%
2.3
157 Number of trips before a driver got banned lyft medium
5%
4.2
158 First trip completion rate lyft medium
21%
4.2
159 Transaction volume from suspended accounts ebay easy
51%
2.2
160 Sellers with no sales by day ebay hard
7%
2.3
161 Biggest sales day ebay easy
19%
2.2
162 Number of orders per brand walmart easy
40%
3.1
163 Average number of orders per brand walmart easy
36%
2.2
164 Orders distribution by brand walmart easy
22%
2.2
165 Session stitching walmart hard
15%
4.2
166 Top 10 customers based on spend growth walmart medium
13%
4.2
167 Top country in video streaming tiktok easy
24%
2.2
168 Average number of streams in the US tiktok medium
13%
3.2
169 Same day streams tiktok easy
29%
2.2
170 Top 3 countries by average watch time tiktok easy
10%
2.2
171 Binge watches tiktok easy
19%
2.2
172 Comments distribution social hard
13%
3.2
173 User Popularity Percentage social medium
5%
2.2
174 Closed accounts social easy
18%
2.2
175 Employees' email account amazon easy
11%
2.1
176 Employees' annual bonus amazon easy
11%
2.3
177 Purchases by platform report amazon medium
9%
2.3
178 Members who worked at both Microsoft and Google linkedin medium
36%
2.3
179 Members who ever moved from Microsoft to Google linkedin medium
35%
3.1
180 Members moved from Microsoft to Google directly. linkedin hard
16%
4.4
181 Users who watched less than one hour of Netflix netflix easy
23%
2.2
182 Top 5 content by number of watchers netflix medium
4%
4.1
183 Top 5 movies by number of watchers netflix easy
33%
2.2
184 Top 5 movies by watch time netflix medium
7%
2.2
185 Top 5 non-English contents by watch time netflix medium
53%
2.2
186 Average comments per question google easy
50%
2.2
187 Comment distribution at Google Forum google easy
50%
2.2
188 Top 1 popular question by department google hard
100%
4.2
189 Campaign activation date twitter medium
0%
4.1
190 Twitter campaign spend report twitter hard
50%
2.2
191 Number of replies by group twitter medium
100%
3.2
192 Number of replies to the original tweet by group twitter medium
100%
2.2
193 Difference of replies by testing groups twitter medium
100%
2.2
194 Daily active users report for new market snap easy - 3.2
195 MoM user growth snap hard - 4.4
196 User segments report snap hard - 2.2
197 Students who didn't finish all subjects snap easy - 2.2
198 Average score per subject snap easy - 2.2
199 Students improvement snap hard - 4.4
200 Last week's absent students snap medium - 2.1
201 Top 3 students for each subject snap medium - 4.2
202 Monthly active paid subscriptions subscription easy - 2.2
203 Top 5 products by country by month search engine easy - 4.2
204 AB testing sanity check search engine easy - 2.2
205 Search results recall search engine medium - 2.2
206 Search results recall by testing group search engine medium - 2.2
207 Results shown rate by group search engine easy - 2.2.1
208 Top 3 urls by testing groups search engine medium - 4.2
209 Card issuer customers count visa easy - 2.2
210 Issuer and merchant report visa easy - 2.1
211 High spenders by issuer visa easy - 2.1
212 Top issuing bank by category visa hard - 2.1
213 Interchange revenue by issuer and merchant category visa easy - 3.2
214 D30 retention rate gaming hard - 2.2
215 Monthly active users gaming hard - 2.2
216 Highest spender gaming hard - 2.2

Disclaimer: SQLPad collects questions and their associated data from the internet, but we are not associated with any of the companies or organizations that may be mentioned in these questions. While we strive to provide accurate and up-to-date information, we cannot guarantee the accuracy or completeness of the information provided. Users should exercise their own discretion when using the platform and should not rely solely on the information provided. By using SQLPad, you acknowledge and agree that we are not responsible for any errors or inaccuracies in the information, and that you assume all risks associated with using the platform. You also agree to our terms and conditions.