Course Content
Practice SQL with Cinema Database
Practice SQL with Cinema Database
The Best Genre
Task
Swipe to start coding
You have to return two records:
- first one contains the most popular genre according to the sales
- second one contains the best genre according to the rating
To evaluate these metrics, use total sales and average rating respectively. Name the column genre.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
Section 2. Chapter 5
The Best Genre
Task
Swipe to start coding
You have to return two records:
- first one contains the most popular genre according to the sales
- second one contains the best genre according to the rating
To evaluate these metrics, use total sales and average rating respectively. Name the column genre.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
Section 2. Chapter 5
Switch to desktop for real-world practiceContinue from where you are using one of the options below