SQL Coding Questions & Answers

Practice 216 online coding questions and become a SQL expert.

ALL QUESTIONS

Advertising Ai Ecommerce Education Fintech Food Delivery Forum Gaming Hospitality Human Resource Mobile Music Search Engine Social Subscription Video Streaming

ID Title Level FTPR Lecture
1 Top store for movie sales easy
30%
2.1
2 Top 3 movie categories by sales easy
47%
2.1
3 Top 5 shortest movies easy
53%
2.1
4 Staff without a profile image easy
67%
2.1
5 Monthly revenue easy
24%
2.2
6 Daily revenue in June, 2020 medium
11%
2.2
7 Unique customers count by month easy
19%
2.2
8 Average customer spend by month easy
22%
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
24%
2.3
12 Actors' last name ending in 'EN' or 'RY' easy
30%
2.3
13 Actors' first name medium
13%
2.3
14 Good days and bad days hard
4%
2.3
15 Fast movie watchers vs slow watchers hard
5%
2.3
16 Staff who live in Woodridge easy
72%
2.1
17 GROUCHO WILLIAMS’ actor_id easy
65%
2.1
18 Top film category easy
25%
2.2
19 Most productive actor medium
14%
2.2
20 Customer who spent the most medium
15%
2.2
21 Customer who rented the most medium
20%
2.2
22 Average cost per rental transaction easy
43%
2.3
23 Average spend per customer in Feb 2020 easy
16%
2.2
24 Films with more than 10 actors medium
20%
2.3
25 Shortest film easy
46%
2.3
26 Second shortest film easy
29%
2.3
27 Film with the largest cast easy
27%
2.3
28 Film with the second largest cast medium
25%
2.3
29 Second highest spend customer medium
16%
2.3
30 Inactive customers in May easy
21%
2.3
31 Movies that have not been returned easy
27%
2.3
32 Unpopular movies hard
16%
2.3
33 Returning customers hard
8%
2.3
34 Stocked up movies easy
28%
2.3
35 Film length report easy
26%
2.3
36 Actors from film 'AFRICAN EGG' easy
36%
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
15%
3.1
41 Productive actors vs less-productive actors hard
6%
3.2
42 Films that are in stock vs not in stock medium
11%
3.2
43 Customers who rented vs. those who did not medium
9%
3.2
44 In-demand vs not-in-demand movies medium
6%
3.2
45 Movie inventory optimization hard
7%
3.2
46 Actors and customers whose last name starts with 'A' easy
32%
3.3
47 Actors and customers whose first names end in 'D'. easy
45%
3.3
48 Movie and TV actors easy
43%
3.1
49 Top 3 money making movie categories medium
19%
3.1
50 Top 5 cities for movie rentals easy
23%
3.1