Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Sales of Genres in Cities | Ordering Data
Practice SQL with Cinema Database
course content

Conteúdo do Curso

Practice SQL with Cinema Database

Practice SQL with Cinema Database

1. Aggregating Data
Cinema's databaseOld vs New MoviesThe Best & Worst MoviesBest Selling MoviesMovie for PhoebeTop-3 Most Selling GenresMovies in 5th CinemaMovies Rating
2. Ordering Data
Cinema for MaryJames Cameron Movies SalesMost Popular GenresMovies for GeorgeThe Best GenreSales of Genres in CitiesSales Based on Rating
3. Join Data
Top-3 Selling MoviesCinema for MargotCinemas Like 'Central'Rating of DirectorsDirectors IncomeManagers IncomeTwo Most Popular Movies

Sales of Genres in Cities

Tarefa

Which genre gives the biggest income in each city? To solve it:

  • Calculate the total sales for each genre in each city: group records by city and genre.
  • Order the records by city lexicographically and then by total sales, starting with most selling genre.

Output data under columns city, genre, and sales.

Tarefa

Which genre gives the biggest income in each city? To solve it:

  • Calculate the total sales for each genre in each city: group records by city and genre.
  • Order the records by city lexicographically and then by total sales, starting with most selling genre.

Output data under columns city, genre, and sales.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Seção 2. Capítulo 6
toggle bottom row

Sales of Genres in Cities

Tarefa

Which genre gives the biggest income in each city? To solve it:

  • Calculate the total sales for each genre in each city: group records by city and genre.
  • Order the records by city lexicographically and then by total sales, starting with most selling genre.

Output data under columns city, genre, and sales.

Tarefa

Which genre gives the biggest income in each city? To solve it:

  • Calculate the total sales for each genre in each city: group records by city and genre.
  • Order the records by city lexicographically and then by total sales, starting with most selling genre.

Output data under columns city, genre, and sales.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Seção 2. Capítulo 6
toggle bottom row

Sales of Genres in Cities

Tarefa

Which genre gives the biggest income in each city? To solve it:

  • Calculate the total sales for each genre in each city: group records by city and genre.
  • Order the records by city lexicographically and then by total sales, starting with most selling genre.

Output data under columns city, genre, and sales.

Tarefa

Which genre gives the biggest income in each city? To solve it:

  • Calculate the total sales for each genre in each city: group records by city and genre.
  • Order the records by city lexicographically and then by total sales, starting with most selling genre.

Output data under columns city, genre, and sales.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Tarefa

Which genre gives the biggest income in each city? To solve it:

  • Calculate the total sales for each genre in each city: group records by city and genre.
  • Order the records by city lexicographically and then by total sales, starting with most selling genre.

Output data under columns city, genre, and sales.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Seção 2. Capítulo 6
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
We're sorry to hear that something went wrong. What happened?
some-alt