Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Movies Rating | Aggregating Data
Practice SQL with Cinema Database
course content

Conteúdo do Curso

Practice SQL with Cinema Database

Practice SQL with Cinema Database

1. Aggregating Data
2. Ordering Data
3. Join Data

Movies Rating

Tarefa

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

Tarefa

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

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Seção 1. Capítulo 8
toggle bottom row

Movies Rating

Tarefa

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

Tarefa

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

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Seção 1. Capítulo 8
toggle bottom row

Movies Rating

Tarefa

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

Tarefa

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

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Tarefa

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

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Seção 1. Capítulo 8
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
We're sorry to hear that something went wrong. What happened?
some-alt