Зміст курсу
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Cinema for Margot
Завдання
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.
Завдання
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.
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівВсе було зрозуміло?
Cinema for Margot
Завдання
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.
Завдання
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.
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівВсе було зрозуміло?
Cinema for Margot
Завдання
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.
Завдання
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.
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівВсе було зрозуміло?
Завдання
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.
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівПерейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів