Зміст курсу
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Movies Rating
Завдання
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).
Дякуємо за ваш відгук!
Movies Rating
Завдання
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).
Дякуємо за ваш відгук!
Movies Rating
Завдання
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).
Дякуємо за ваш відгук!
Завдання
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).