Contenido del Curso
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Cinema for Margot
Tarea
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.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
Cinema for Margot
Tarea
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.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
Cinema for Margot
Tarea
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.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
Tarea
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.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opcionesCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones