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.
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
.