Kursinnhold
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Movies Rating
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
Movies Rating
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