Kursusindhold
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Best Selling Movies
Opgave
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).
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederVar alt klart?
Tak for dine kommentarer!
Sektion 1. Kapitel 4
Best Selling Movies
Opgave
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).
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederVar alt klart?
Tak for dine kommentarer!
Sektion 1. Kapitel 4
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder