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

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
36 Actors from film 'AFRICAN EGG' easy
37%
3.1
37 Most popular movie category easy
17%
3.1
38 Most popular movie category (name and id) medium
18%
3.1
39 Most productive actor with inner join easy
23%
3.1
40 Top 2 most rented movie in June 2020 medium
16%
3.1
41 Productive actors vs less-productive actors hard
5%
3.2
42 Films that are in stock vs not in stock medium
13%
3.2
43 Customers who rented vs. those who did not medium
12%
3.2
44 In-demand vs not-in-demand movies medium
5%
3.2
45 Movie inventory optimization hard
9%
3.2
46 Actors and customers whose last name starts with 'A' easy
28%
3.3
47 Actors and customers whose first names end in 'D'. easy
43%
3.3
48 Movie and TV actors easy
44%
3.1
49 Top 3 money making movie categories medium
23%
3.1
50 Top 5 cities for movie rentals easy
18%
3.1