Lære Movies Rating | Aggregating Data

Practice SQL with Cinema Database

Oppgave

Swipe to start coding

For each cinema, let's create a rating of movies: order movies in each cinema by its rating. Display the cinema.label, movie.label, and rating as cinema, movie, and rating columns. Order records by cinema.id and rating (starting with the best).

Løsning

Alt var klart?

Takk for tilbakemeldingene dine!

Seksjon 1. Kapittel 8

single

Spør AI

Spør AI

Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår

Suggested prompts:

Oppsummer dette kapittelet

Explain code

Explain why doesn't solve task

Sveip for å vise menyen

Oppgave

Swipe to start coding

For each cinema, let's create a rating of movies: order movies in each cinema by its rating. Display the cinema.label, movie.label, and rating as cinema, movie, and rating columns. Order records by cinema.id and rating (starting with the best).

Løsning

Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor

Alt var klart?

Takk for tilbakemeldingene dine!

Seksjon 1. Kapittel 8

single

some-alt