Course Content
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Movies Rating
Task
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).
Task
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).
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Movies Rating
Task
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).
Task
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).
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Movies Rating
Task
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).
Task
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).
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Task
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).
Switch to desktop for real-world practiceContinue from where you are using one of the options belowSwitch to desktop for real-world practiceContinue from where you are using one of the options below