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

bookCinemas Like 'Central'

Taak

Swipe to start coding

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.

Oplossing

Was alles duidelijk?

Hoe kunnen we het verbeteren?

Bedankt voor je feedback!

Sectie 3. Hoofdstuk 3
single

single

Vraag AI

expand

Vraag AI

ChatGPT

Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.

Suggested prompts:

Vat dit hoofdstuk samen

Explain code

Explain why doesn't solve task

close

Awesome!

Completion rate improved to 4.55

bookCinemas Like 'Central'

Veeg om het menu te tonen

Taak

Swipe to start coding

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.

Oplossing

Switch to desktopSchakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande opties
Was alles duidelijk?

Hoe kunnen we het verbeteren?

Bedankt voor je feedback!

close

Awesome!

Completion rate improved to 4.55
Sectie 3. Hoofdstuk 3
single

single

some-alt