Course Content
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Best Selling Movies
Task
For each cinema, let's order movies from the most selling to the least one. Print records in the following format: cinema_id, movie_id, sales (for total sales). Remember to order records by cinema's first but by total sales then (starting with the best selling one).
Task
For each cinema, let's order movies from the most selling to the least one. Print records in the following format: cinema_id, movie_id, sales (for total sales). Remember to order records by cinema's first but by total sales then (starting with the best selling one).
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Best Selling Movies
Task
For each cinema, let's order movies from the most selling to the least one. Print records in the following format: cinema_id, movie_id, sales (for total sales). Remember to order records by cinema's first but by total sales then (starting with the best selling one).
Task
For each cinema, let's order movies from the most selling to the least one. Print records in the following format: cinema_id, movie_id, sales (for total sales). Remember to order records by cinema's first but by total sales then (starting with the best selling one).
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Best Selling Movies
Task
For each cinema, let's order movies from the most selling to the least one. Print records in the following format: cinema_id, movie_id, sales (for total sales). Remember to order records by cinema's first but by total sales then (starting with the best selling one).
Task
For each cinema, let's order movies from the most selling to the least one. Print records in the following format: cinema_id, movie_id, sales (for total sales). Remember to order records by cinema's first but by total sales then (starting with the best selling one).
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Task
For each cinema, let's order movies from the most selling to the least one. Print records in the following format: cinema_id, movie_id, sales (for total sales). Remember to order records by cinema's first but by total sales then (starting with the best selling one).
Switch to desktop for real-world practiceContinue from where you are using one of the options belowSwitch to desktop for real-world practiceContinue from where you are using one of the options below