Course Content
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Sales Based on Rating
Task
Return three records under income column in the following order:
- average income of movies with rating from 8.0 to 10.0
- average income of movies with rating from 5.0 to 7.9
- average income of movies with rating from 0.0 to 4.9
Task
Return three records under income column in the following order:
- average income of movies with rating from 8.0 to 10.0
- average income of movies with rating from 5.0 to 7.9
- average income of movies with rating from 0.0 to 4.9
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Section 2. Chapter 7
Sales Based on Rating
Task
Return three records under income column in the following order:
- average income of movies with rating from 8.0 to 10.0
- average income of movies with rating from 5.0 to 7.9
- average income of movies with rating from 0.0 to 4.9
Task
Return three records under income column in the following order:
- average income of movies with rating from 8.0 to 10.0
- average income of movies with rating from 5.0 to 7.9
- average income of movies with rating from 0.0 to 4.9
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Section 2. Chapter 7
Sales Based on Rating
Task
Return three records under income column in the following order:
- average income of movies with rating from 8.0 to 10.0
- average income of movies with rating from 5.0 to 7.9
- average income of movies with rating from 0.0 to 4.9
Task
Return three records under income column in the following order:
- average income of movies with rating from 8.0 to 10.0
- average income of movies with rating from 5.0 to 7.9
- average income of movies with rating from 0.0 to 4.9
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Task
Return three records under income column in the following order:
- average income of movies with rating from 8.0 to 10.0
- average income of movies with rating from 5.0 to 7.9
- average income of movies with rating from 0.0 to 4.9
Switch to desktop for real-world practiceContinue from where you are using one of the options belowSection 2. Chapter 7
Switch to desktop for real-world practiceContinue from where you are using one of the options below