Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Cinemas Like 'Central' | Join Data
Practice SQL with Cinema Database
course content

Contenido del 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

Cinemas Like 'Central'

Tarea

Find all cinemas, that in a schedule have at least one movie, as a cinema 'Central' has. For example, if next cinemas have movies:

  • 'Central' has movies 'The Spiderman', 'Mean Girls', 'Origin'
  • 'Golden' has movies 'The Great Gatsby', 'The Spiderman', 'Origin'
  • 'Ocean' has movies 'Pretty Woman', 'Mean Girls', 'Titanic'
  • 'Superstar' has movies 'The Spiderman', 'Mean Girls', 'Origin', and 'Romeo and Juliet'

All these cinemas have at least one movie as Central has, so they are all correct.

Note that these examples are not the same as the data in the table: you can't use hardcoded values of the movies. Your query should work even if we change the records in the database.

Name the column of results cinema.

Tarea

Find all cinemas, that in a schedule have at least one movie, as a cinema 'Central' has. For example, if next cinemas have movies:

  • 'Central' has movies 'The Spiderman', 'Mean Girls', 'Origin'
  • 'Golden' has movies 'The Great Gatsby', 'The Spiderman', 'Origin'
  • 'Ocean' has movies 'Pretty Woman', 'Mean Girls', 'Titanic'
  • 'Superstar' has movies 'The Spiderman', 'Mean Girls', 'Origin', and 'Romeo and Juliet'

All these cinemas have at least one movie as Central has, so they are all correct.

Note that these examples are not the same as the data in the table: you can't use hardcoded values of the movies. Your query should work even if we change the records in the database.

Name the column of results cinema.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

Sección 3. Capítulo 3
toggle bottom row

Cinemas Like 'Central'

Tarea

Find all cinemas, that in a schedule have at least one movie, as a cinema 'Central' has. For example, if next cinemas have movies:

  • 'Central' has movies 'The Spiderman', 'Mean Girls', 'Origin'
  • 'Golden' has movies 'The Great Gatsby', 'The Spiderman', 'Origin'
  • 'Ocean' has movies 'Pretty Woman', 'Mean Girls', 'Titanic'
  • 'Superstar' has movies 'The Spiderman', 'Mean Girls', 'Origin', and 'Romeo and Juliet'

All these cinemas have at least one movie as Central has, so they are all correct.

Note that these examples are not the same as the data in the table: you can't use hardcoded values of the movies. Your query should work even if we change the records in the database.

Name the column of results cinema.

Tarea

Find all cinemas, that in a schedule have at least one movie, as a cinema 'Central' has. For example, if next cinemas have movies:

  • 'Central' has movies 'The Spiderman', 'Mean Girls', 'Origin'
  • 'Golden' has movies 'The Great Gatsby', 'The Spiderman', 'Origin'
  • 'Ocean' has movies 'Pretty Woman', 'Mean Girls', 'Titanic'
  • 'Superstar' has movies 'The Spiderman', 'Mean Girls', 'Origin', and 'Romeo and Juliet'

All these cinemas have at least one movie as Central has, so they are all correct.

Note that these examples are not the same as the data in the table: you can't use hardcoded values of the movies. Your query should work even if we change the records in the database.

Name the column of results cinema.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

Sección 3. Capítulo 3
toggle bottom row

Cinemas Like 'Central'

Tarea

Find all cinemas, that in a schedule have at least one movie, as a cinema 'Central' has. For example, if next cinemas have movies:

  • 'Central' has movies 'The Spiderman', 'Mean Girls', 'Origin'
  • 'Golden' has movies 'The Great Gatsby', 'The Spiderman', 'Origin'
  • 'Ocean' has movies 'Pretty Woman', 'Mean Girls', 'Titanic'
  • 'Superstar' has movies 'The Spiderman', 'Mean Girls', 'Origin', and 'Romeo and Juliet'

All these cinemas have at least one movie as Central has, so they are all correct.

Note that these examples are not the same as the data in the table: you can't use hardcoded values of the movies. Your query should work even if we change the records in the database.

Name the column of results cinema.

Tarea

Find all cinemas, that in a schedule have at least one movie, as a cinema 'Central' has. For example, if next cinemas have movies:

  • 'Central' has movies 'The Spiderman', 'Mean Girls', 'Origin'
  • 'Golden' has movies 'The Great Gatsby', 'The Spiderman', 'Origin'
  • 'Ocean' has movies 'Pretty Woman', 'Mean Girls', 'Titanic'
  • 'Superstar' has movies 'The Spiderman', 'Mean Girls', 'Origin', and 'Romeo and Juliet'

All these cinemas have at least one movie as Central has, so they are all correct.

Note that these examples are not the same as the data in the table: you can't use hardcoded values of the movies. Your query should work even if we change the records in the database.

Name the column of results cinema.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

Tarea

Find all cinemas, that in a schedule have at least one movie, as a cinema 'Central' has. For example, if next cinemas have movies:

  • 'Central' has movies 'The Spiderman', 'Mean Girls', 'Origin'
  • 'Golden' has movies 'The Great Gatsby', 'The Spiderman', 'Origin'
  • 'Ocean' has movies 'Pretty Woman', 'Mean Girls', 'Titanic'
  • 'Superstar' has movies 'The Spiderman', 'Mean Girls', 'Origin', and 'Romeo and Juliet'

All these cinemas have at least one movie as Central has, so they are all correct.

Note that these examples are not the same as the data in the table: you can't use hardcoded values of the movies. Your query should work even if we change the records in the database.

Name the column of results cinema.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
Sección 3. Capítulo 3
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
We're sorry to hear that something went wrong. What happened?
some-alt