Practice Questions

Medium SQL Interview Questions

Master SQL interview patterns with structured question sets, company filters, and run-ready challenges.

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

Questions Showing

70

Companies

23

Access Tier

Free

Level: Medium Clear filters
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 interview questions and sample data from public sources. We are not affiliated with the companies mentioned in these exercises. Please review our terms and conditions.