SQL Interview Questions Based on Real World Data

🏋ī¸â€â™‚ī¸ It's crunch time! Solve 80 SQL coding questions and ace your data interview.

Single Table Operation: Lecture 2: COUNT, SUM, AVERAGE, MIN, MAX, GROUP BY, HAVING
ID Title Level FTPR Lecture
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
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
21 Customer who rented the most medium
21%
2.2
23 Average spend per customer in Feb 2020 easy
0%
2.2