SQL Interview Questions

Practice 180 online SQL coding questions and ace your data job interview.

Nervous about your SQL interview? Try instamentor and hire a FAANG mentor for 1:1 job interview coaching.

ALL QUESTIONS

Affirm SQL Interview Questions Airbnb SQL Interview Questions Afterpay SQL Interview Questions Amazon SQL Interview Questions Doordash SQL Interview Questions Dropbox SQL Interview Questions Ebay SQL Interview Questions Facebook SQL Interview Questions Google SQL Interview Questions Linkedin SQL Interview Questions Lyft SQL Interview Questions Robinhood SQL Interview Questions Spotify SQL Interview Questions Tiktok SQL Interview Questions Uber SQL Interview Questions Walmart SQL Interview Questions

Single Table Operation: Lecture 2: COUNT, SUM, AVERAGE, MIN, MAX, GROUP BY, HAVING
ID Title Level FTPR Lecture
5 Monthly revenue easy
30%
2.2
6 Daily revenue in June, 2020 easy
8%
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
13%
2.2
18 Top film category easy
27%
2.2
19 Most productive actor medium
15%
2.2
20 Customer who spent the most medium
20%
2.2
21 Customer who rented the most medium
19%
2.2
23 Average spend per customer in Feb 2020 easy
9%
2.2
81 How many people searched on new year's day facebook easy
28%
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 easy
10%
2.2
85 Top 5 queries based on click through rate on new year's day facebook hard
7%
2.2
86 Top song in the US spotify easy
15%
2.2
89 Top 5 artists in the US spotify medium
17%
2.2
93 number of sales for each product this month amazon easy
16%
2.2
95 Candidate products for subscription amazon hard
4%
2.2
96 Overall acceptance rate facebook easy
14%
2.2
97 Social influencer facebook easy
4%
2.2
98 Most popular user facebook easy
32%
2.2
101 Average number of visits per user google easy
0%
2.2
106 Mobile vs. web google medium
0%
2.2
107 Customer count by platform google medium
20%
2.2
112 Top 3 customers amazon easy
42%
2.2
124 Active restaurants by city uber easy
50%
2.2
125 Active restaurants with fewer than 5 trips per city uber easy
0%
2.2
128 Completion rate uber easy
20%
2.2
130 Newly created accounts affirm easy
33%
2.2
132 Top 3 trending countries affirm medium
0%
2.2
133 Small departments robinhood easy
0%
2.2
134 Expensive departments robinhood medium
0%
2.2
143 Customer purchase report afterpay easy
100%
2.2
146 Purchase by platform afterpay easy
100%
2.2
149 fans by video category tiktok easy
100%
2.2
153 Project ROI dropbox easy
33%
2.2
154 Rideshare completion rate lyft easy
50%
2.2
159 Transaction volume from suspended accounts ebay easy
0%
2.2
161 Biggest sales day ebay easy
100%
2.2
163 Average number of orders per brand walmart easy
67%
2.2
164 Orders distribution by brand walmart easy
67%
2.2
167 Top country in video streaming amazon easy
50%
2.2
169 Same day streams amazon easy
50%
2.2
170 Top 3 countries by average watch time amazon easy
50%
2.2
171 Binge watches amazon easy
67%
2.2
173 Facebook Popularity Percentage facebook medium
0%
2.2
174 FB Closed accounts facebook easy
13%
2.2