SQL Interview Questions Based on Real World Data

🏋️‍♂️ It's crunch time! Solve 80 SQL coding questions and ace your data interview.

ID Title Level FTPR Lecture
1 Top store for movie sales easy
42%
2.1
2 Top 3 movie categories by sales easy
37%
2.1
3 Top 5 shortest movies easy
51%
2.1
4 Staff without a profile image easy
76%
2.1
5 Monthly revenue easy
37%
2.2
6 Daily revenue in June, 2020 easy
6%
2.2
7 Unique customers count by month easy
17%
2.2
8 Average customer spend by month medium
13%
2.2
9 Number of high spend customers by month medium
2%
2.2
10 Min and max spend medium
10%
2.2
11 Actors' last name easy
30%
2.3
12 Actors' last name ending in 'EN' or 'RY' easy
36%
2.3
13 Actors' first name medium
9%
2.3
14 Good days and bad days difficult
3%
2.3
15 Fast movie watchers vs slow watchers difficult
0%
2.3
16 Staff who live in Woodridge easy
71%
2.1
17 GROUCHO WILLIAMS’ actor_id easy
61%
2.1
18 Top film category easy
23%
2.2
19 Most productive actor medium
13%
2.2
20 Customer who spent the most medium
14%
2.2