Practice SQL with Cinema Database

Course Content

Practice SQL with Cinema Database

Movies Rating

Task

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

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 8

toggle bottom row

Movies Rating

Task

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

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 8

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

some-alt