Lære Best Selling Movies | Aggregating Data

Practice SQL with Cinema Database

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

Var alt klart?

Tak for dine kommentarer!

Sektion 1. Kapitel 4

single

Spørg AI

Spørg AI

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

Suggested prompts:

Opsummér dette kapitel

Explain code

Explain why doesn't solve task

Stryg for at vise menuen

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 muligheder

Var alt klart?

Tak for dine kommentarer!

Sektion 1. Kapitel 4

single

some-alt