Зміст курсу
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Cinemas Like 'Central'
Завдання
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
.
Дякуємо за ваш відгук!
Cinemas Like 'Central'
Завдання
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
.
Дякуємо за ваш відгук!
Cinemas Like 'Central'
Завдання
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
.
Дякуємо за ваш відгук!
Завдання
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
.