Practice SQL with Cinema Database

Swipe to show menu

Best Selling Movies

Task

Swipe to start coding

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).

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 4

single

Ask AI

Ask AI

Ask anything or try one of the suggested questions to begin our chat

Best Selling Movies

Task

Swipe to start coding

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).

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Swipe to show menu

some-alt