Conteúdo do Curso
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Cinema for Margot
Tarefa
Margot can't decide which cinema she should visit today. There are three criteria for the choice (in order of importance):
- number of different movies in the cinema
- average rating of the movies in the cinema
- number of different genres in the cinema
Help Margot to make a choice: create a rating of cinemas based on these criteria. Print the cinema label as cinema
and then 3 columns of criteria's values: c1
, c2
, and c3
. Order rows by these criteria in order of importance.
Obrigado pelo seu feedback!
Cinema for Margot
Tarefa
Margot can't decide which cinema she should visit today. There are three criteria for the choice (in order of importance):
- number of different movies in the cinema
- average rating of the movies in the cinema
- number of different genres in the cinema
Help Margot to make a choice: create a rating of cinemas based on these criteria. Print the cinema label as cinema
and then 3 columns of criteria's values: c1
, c2
, and c3
. Order rows by these criteria in order of importance.
Obrigado pelo seu feedback!
Cinema for Margot
Tarefa
Margot can't decide which cinema she should visit today. There are three criteria for the choice (in order of importance):
- number of different movies in the cinema
- average rating of the movies in the cinema
- number of different genres in the cinema
Help Margot to make a choice: create a rating of cinemas based on these criteria. Print the cinema label as cinema
and then 3 columns of criteria's values: c1
, c2
, and c3
. Order rows by these criteria in order of importance.
Obrigado pelo seu feedback!
Tarefa
Margot can't decide which cinema she should visit today. There are three criteria for the choice (in order of importance):
- number of different movies in the cinema
- average rating of the movies in the cinema
- number of different genres in the cinema
Help Margot to make a choice: create a rating of cinemas based on these criteria. Print the cinema label as cinema
and then 3 columns of criteria's values: c1
, c2
, and c3
. Order rows by these criteria in order of importance.