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

Chapter 2: Single Table Operation

ID Title Level FTPR Lecture
1 Top store for movie sales easy
35%
2.1
2 Top 3 movie categories by sales easy
49%
2.1
3 Top 5 shortest movies easy
55%
2.1
4 Staff without a profile image easy
69%
2.1
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
11 Actors' last name easy
25%
2.3
12 Actors' last name ending in 'EN' or 'RY' easy
32%
2.3
13 Actors' first name medium
15%
2.3
14 Good days and bad days hard
2%
2.3
15 Fast movie watchers vs slow watchers hard
4%
2.3
16 Staff who live in Woodridge easy
74%
2.1
17 GROUCHO WILLIAMS’ actor_id easy
68%
2.1
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
22 Average cost per rental transaction easy
42%
2.3
23 Average spend per customer in Feb 2020 easy
9%
2.2
24 Films with more than 10 actors medium
18%
2.3
25 Shortest film easy
49%
2.3
26 Second shortest film medium
30%
2.3
27 Film with the largest cast easy
19%
2.3
28 Film with the second largest cast medium
24%
2.3
29 Second highest spend customer medium
15%
2.3
30 Inactive customers in May easy
21%
2.3
31 Movies that have not been returned easy
19%
2.3
32 Unpopular movies hard
14%
2.3
33 Returning customers hard
6%
2.3
34 Stocked up movies easy
24%
2.3
35 Film length report easy
25%
2.3
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
92 Acceptance rate first week of 2021 facebook easy
11%
2.1
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
102 Histogram by visit session duration google hard
13%
2.3
106 Mobile vs. web google medium
0%
2.2