SQLPad
Sign In

SQL Coding Questions & Answers

Master the world of data! Dive into 216 SQL & Python online coding questions and emerge as a data expert!

ALL QUESTIONS

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

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