Course Content
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Cinema for Margot
Swipe to show code editor
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.
Thanks for your feedback!
Cinema for Margot
Swipe to show code editor
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.
Thanks for your feedback!