Welcome to the SQL Bootcamp! In this course, we'll be working with data on cinemas and movies. We have data stored in the database with the next schema:

This database consists of six tables:

 - `director` contains info about te various movies directors.
 - `manager` contains a list of cinemas' managers.
 - `genre` stores list of movies genres.
 - `cinema` contains a list of cinemas. Each cinema has `label` column as a cinema's name, `address`, `manager_id` that refers to `manager` table, and `city` in which the cinema is located.
 - `movie` table stores data about `label`, `year` of release, `genre_id`, and `director_id`, as well as the movie `rating`.
 - `schedule` table contains records of ids' pairs: `cinema_id` and `movie_id`. It corresponds to which movie has the box office in which cinema and the total sales *of this movie in this cinema*.

 Here we can see the records of the `movie` table.

<div style='height:300px;overflow:scroll;'><table style='border-collapse: collapse'><tr><th>id</th><th>label</th><th>rating</th><th>director_id</th><th>genre_id</th><th>yr</th></tr><tr><td>1</td><td>The Lord of the Rings</td><td>9.4</td><td>2</td><td>3</td><td>2003</td></tr><tr><td>2</td><td>The Shawshank Redemption</td><td>9.3</td><td>3</td><td>1</td><td>1994</td></tr><tr><td>3</td><td>Forrest Gump</td><td>9.3</td><td>4</td><td>1</td><td>1994</td></tr><tr><td>4</td><td>The Mask of Zorro</td><td>7.7</td><td>6</td><td>2</td><td>1998</td></tr><tr><td>5</td><td>Avatar</td><td>9.0</td><td>1</td><td>3</td><td>2009</td></tr><tr><td>6</td><td>Taxi 3</td><td>7.6</td><td>5</td><td>4</td><td>2003</td></tr><tr><td>7</td><td>The Emoji Movie</td><td>1.2</td><td>7</td><td>4</td><td>2017</td></tr><tr><td>8</td><td>Inception</td><td>8.9</td><td>8</td><td>5</td><td>2010</td></tr><tr><td>9</td><td>The Sisterhood of the Traveling Pants</td><td>6.5</td><td>9</td><td>6</td><td>2005</td></tr><tr><td>10</td><td>Roman Holiday</td><td>8.9</td><td>10</td><td>6</td><td>1953</td></tr><tr><td>11</td><td>Titanic</td><td>7.8</td><td>1</td><td>1</td><td>1997</td></tr></table></div>

To see other tables' content, run the `select` query using the code editor.

**Note** that some fields may contain NULL values; some movies may not be at the box office, or some directors have not produced films among present in the `movie` table. This database is created for studying, but it represents the real-like databases that can contain imperfect data or some extra data. Don't be afraid of it, but keep in mind.

> The order of the rows matters. If you are unable to submit a valid query due to **Incorrect Output**, double check that the rows are arranged as requested in the assignment. Then check that the column names are correct.

Dive into intensive SQL Bootcamp! Upgrade your skills in creating queries. A lot of practice, different tasks, and a huge database - learn how to manipulate data with SQL!

Cinema's database