Common SQL Interview Questions

Master the world of data! Dive into common SQL & Python interview questions and get ready for your SQL interview!

ALL QUESTIONS

affirm afterpay airbnb amazon apple doordash dropbox ebay facebook google linkedin lyft microsoft netflix robinhood roblox snap spotify tiktok twitter uber visa walmart

Level: medium


ID Title Level FTPR Lecture
6 Daily revenue in June, 2020 medium
12%
2.2
9 Number of high spend customers by month medium
4%
2.2
13 Actors' first name medium
14%
2.3
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
24 Films with more than 10 actors medium
19%
2.3
28 Film with the second largest cast medium
26%
2.3
29 Second highest spend customer medium
14%
2.3
33 Returning customers medium
8%
2.3
38 Most popular movie category (name and id) medium
19%
3.1
40 Top 2 most rented movie in June 2020 medium
14%
3.1
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
49 Top 3 money making movie categories medium
18%
3.1
54 Customer groups by movie rental spend medium
20%
3.2
55 Busy days and slow days medium
10%
3.2
59 Percentage of revenue per movie by category medium
6%
4.1
62 Shortest film by category medium
8%
4.2
66 Movie percentiles by revenue by category medium
18%
4.3
72 Days when they became happy customers medium
10%
4.2
75 Top customer by movie category medium
26%
4.2
78 Quartiles buckets by number of rentals medium
25%
4.3
83 Top search_query in US and UK on new year's day facebook medium
6%
4.2
84 Click through rate on new year's day facebook medium
9%
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
94 Top 3 products vs. bottom 3 products amazon medium
7%
3.3
99 Page recommendation facebook medium
13%
3.1
100 Advertiser ROI facebook medium
8%
3.2
103 Median and average session duration by day of the week google medium
20%
4.3
106 Mobile vs. web google medium
10%
2.2
107 Customer count by platform google medium
17%
2.2
110 Most popular product by category amazon medium
12%
4.2
111 Second most popular product amazon medium
16%
2.1
123 Top listing in the United States, United Kingdom and Canada airbnb medium
10%
4.2
129 Top 3 and bottom 3 courier uber medium
9%
3.3
132 Top 3 trending countries affirm medium
9%
2.2
134 Expensive departments robinhood medium
38%
2.2
137 Extremely late first orders doordash medium
9%
4.2
139 Poor first delivery experience doordash medium
17%
4.2
144 Third order afterpay medium
9%
4.2
148 Most popular video category google medium
13%
4.2
157 Number of trips before a driver got banned lyft medium
10%
4.2
158 First trip completion rate lyft medium
22%
4.2
166 Top 10 customers based on spend growth walmart medium
11%
4.2
168 Average number of streams in the US tiktok medium
13%
3.2
173 User Popularity Percentage facebook medium
11%
2.2
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
182 Top 5 content by number of watchers netflix medium
9%
4.1
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
189 Campaign activation date twitter medium
19%
4.1
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
200 Last week's absent students snap medium
67%
2.1
205 Search results recall apple medium
30%
2.2
206 Search results recall by testing group apple medium
30%
2.2
207 Results shown rate by group apple medium
50%
2.2
211 Top issuer by category visa medium
30%
4.2
214 D30 (30days) retention rate roblox medium
20%
2.2
218 Total Amount Spent by Each Customer microsoft medium - 2.1
219 Inactive Customers in the New Year of 2024 microsoft medium - 2.1
224 Categories with High Average Product Price microsoft medium - 2.1

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.