The Database Model

The databse and all the tables are created.

First, you could use SHOW tables; to check the existing tables, and then SELECT * FROM ... to see the data records.

Questions:

Q1. List the films where the yr is 1962 [Show id, title].

Q2. List all of the Star Trek movies, include the id, title and yr (all of these movies include the words Star Trek in the title). Order results by year.

Q3. List the films in which Leonardo DiCaprio has appeared.

Q4: List all the people who have worked with Tom Hanks.

Input your SQL code here:

Result of your query: