Practice Questions

COUNT, SUM, AVERAGE, MIN, MAX, GROUP BY, HAVING 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

69

Companies

23

Access Tier

Free

Single Table: COUNT, SUM, AVERAGE, MIN, MAX, GROUP BY, HAVING Clear filters
ID Title Level FTPR Lecture
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
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
23 Average spend per customer in Feb 2020 Easy

16%

 2.2
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
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
89 Top 5 artists in the US spotify Medium

13%

 2.2
93 number of sales for each product this month amazon Easy

20%

 2.2
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
101 Average number of visits per user google Easy

14%

 2.2
106 Mobile vs. web google Medium

10%

 2.2
107 Customer count by platform google Medium

17%

 2.2
112 Top 3 customers amazon Easy

30%

 2.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
128 Completion rate uber Easy

26%

 2.2
130 Newly created accounts affirm Easy

37%

 2.2
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
143 Customer purchase report afterpay Easy

14%

 2.2
146 Purchase by platform afterpay Easy

14%

 2.2
149 fans by video category google Easy

36%

 2.2
153 Project ROI dropbox Easy

18%

 2.2
154 Rideshare completion rate lyft Easy

25%

 2.2
159 Transaction volume from suspended accounts ebay Easy

58%

 2.2
161 Biggest sales day ebay Easy

20%

 2.2
163 Average number of orders per brand walmart Easy

32%

 2.2
164 Orders distribution by brand walmart Easy

28%

 2.2
167 Top country in video streaming tiktok Easy

28%

 2.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
173 User Popularity Percentage facebook Medium

11%

 2.2
174 Closed accounts facebook Easy

23%

 2.2
181 Users who watched less than one hour of Netflix netflix Easy

19%

 2.2
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
190 Twitter campaign spend report twitter Hard

22%

 2.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
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
202 Monthly active paid subscriptions apple Hard

50%

 2.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
209 Card issuer customers count visa Easy

100%

 2.2
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

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.