Conteúdo do Curso
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Most Popular Genres
Tarefa
The manager of Ocean
cinema needs analytics: what genres are the most popular in his cinema? Rank it based on total sales for each genre.
Print genre
and sales
columns. sales
contains the total sales in Ocean
cinema for each genre. Reorder the records starting with the most popular genre.
Tarefa
The manager of Ocean
cinema needs analytics: what genres are the most popular in his cinema? Rank it based on total sales for each genre.
Print genre
and sales
columns. sales
contains the total sales in Ocean
cinema for each genre. Reorder the records starting with the most popular genre.
Tudo estava claro?
Most Popular Genres
Tarefa
The manager of Ocean
cinema needs analytics: what genres are the most popular in his cinema? Rank it based on total sales for each genre.
Print genre
and sales
columns. sales
contains the total sales in Ocean
cinema for each genre. Reorder the records starting with the most popular genre.
Tarefa
The manager of Ocean
cinema needs analytics: what genres are the most popular in his cinema? Rank it based on total sales for each genre.
Print genre
and sales
columns. sales
contains the total sales in Ocean
cinema for each genre. Reorder the records starting with the most popular genre.
Tudo estava claro?
Most Popular Genres
Tarefa
The manager of Ocean
cinema needs analytics: what genres are the most popular in his cinema? Rank it based on total sales for each genre.
Print genre
and sales
columns. sales
contains the total sales in Ocean
cinema for each genre. Reorder the records starting with the most popular genre.
Tarefa
The manager of Ocean
cinema needs analytics: what genres are the most popular in his cinema? Rank it based on total sales for each genre.
Print genre
and sales
columns. sales
contains the total sales in Ocean
cinema for each genre. Reorder the records starting with the most popular genre.
Tudo estava claro?
Tarefa
The manager of Ocean
cinema needs analytics: what genres are the most popular in his cinema? Rank it based on total sales for each genre.
Print genre
and sales
columns. sales
contains the total sales in Ocean
cinema for each genre. Reorder the records starting with the most popular genre.