COUNT, SUM, AVERAGE, MIN, MAX, GROUP BY, HAVING SQL Interview Questions

Master the world of data! Dive into 2.2: COUNT, SUM, AVERAGE, MIN, MAX, GROUP BY, HAVING 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

Single Table: COUNT, SUM, AVERAGE, MIN, MAX, GROUP BY, HAVING


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 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.