Practice Questions

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

230

Companies

23

Access Tier

Free

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 facebook Easy

24%

 2.2
82 The top search query on new year's day facebook Easy

13%

 2.2
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
85 Top 4 queries based on click through rate on new year's day facebook 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 facebook Easy

13%

 2.2
97 Social influencer facebook Easy

10%

 2.2
98 Most popular user facebook Easy

33%

 2.2
99 Page recommendation facebook Medium

13%

 3.1
100 Advertiser ROI facebook Medium

8%

 3.2
101 Average number of visits per user google Easy

14%

 2.2
102 Histogram by visit session duration google Hard

17%

 2.3
103 Median and average session duration by day of the week google Medium

20%

 4.3
104 MAU: Monthly active users google Easy

20%

 3.3
105 Number of days gap between last two actions google Hard

8%

 4.2
106 Mobile vs. web google Medium

10%

 2.2
107 Customer count by platform google 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 google Hard

13%

 4.4
148 Most popular video category google Medium

13%

 4.2
149 fans by video category google Easy

36%

 2.2
150 Countries with above average customers google 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 facebook Hard

13%

 3.2
173 User Popularity Percentage facebook Medium

11%

 2.2
174 Closed accounts facebook 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

67%

 2.1
201 Top 3 students for each subject snap Hard

67%

 4.2
202 Monthly active paid subscriptions apple Hard

50%

 2.2
203 Top product by country by month apple Hard

100%

 4.2
204 AB testing sanity check apple Easy

50%

 2.2
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
208 Top 3 urls by testing groups apple Hard

10%

 4.2
209 Card issuer customers count visa Easy

100%

 2.2
210 Issuer and merchant report visa Easy

100%

 2.1
211 Top issuer by category visa Medium

30%

 4.2
212 Highest spender's issuers visa Hard

0%

 4.2
213 Interchange revenue by issuer and merchant category visa Easy

70%

 3.1
214 D30 (30days) retention rate roblox Medium

20%

 2.2
215 Monthly active users roblox Easy

80%

 2.2
216 Most active customers roblox Hard

10%

 2.2
217 Most engaged customers roblox Hard

10%

 2.1
218 Total Amount Spent by Each Customer microsoft Medium - 2.1
219 Inactive Customers in the New Year of 2024 microsoft Medium - 2.1
220 Most Expensive Product in Each Category microsoft Hard - 2.1
221 Customers With More Than 5 Products in a Single Transaction microsoft Hard - 2.1
222 Product Sales Ranking Within Categories microsoft Hard - 2.1
223 Cumulative Total Sales by Day microsoft Hard - 2.1
224 Categories with High Average Product Price microsoft Medium - 2.1
225 Customer Behavior Analysis microsoft Hard - 2.1
226 Customer Lifetime Value (CLV) and Segmentation microsoft Hard - 2.1
227 Aggregate Sale Amounts per Customer microsoft Hard - 2.1
228 Analyzing Sequential Purchase Behavior microsoft Hard - 2.1
229 Time Between Repeat Purchases microsoft Hard - 4.4
230 Customer Purchase Trend Analysis microsoft Easy - 4.4

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.