INSERT INTO movies VALUES ('Parent Trap','1998','Nancy Meyers','USA','6.1','Adventure','66304095','Charles Shyer');
INSERT INTO Movies VALUES ('Forrest Gump','1994','Robert Zemeckis','USA','8.7','Comedy','673800000','Wendy Finerman');
INSERT INTO Movies VALUES ('Schindlers List','1993','Steven Spielberg','USA','8.9','Biography','317100000','Steven Spielberg');
INSERT INTO Movies VALUES ('Titanic','1997','James Cameron','USA','7.5','Adventure','1843200000','James Cameron');
INSERT INTO Movies VALUES ('Inception',2010','Christopher Nolan',''USA','8.9','Action','825,532,764','James Cameron');
INSERT INTO Movies VALUES ('The Departed','2006','Martin Scorsese','USA','8.5','Crime','289800000','Brad Grey');
INSERT INTO Movies VALUES ('The Shawshank Redemption','1994','Frank Darabont','USA','9.2','Crime','58500000','Niki Marvin');
INSERT INTO Movies VALUES ('Saving Private Ryan','1998','Steven Spielberg','USA','8.5','Action','224700000','Steven Spielberg');



CREATE TABLE Actors (
    Title           varchar(30),
    Year         int,
    Character_name 		varchar(30),
    Actor		 varchar(30)
);

INSERT INTO Actors VALUES ('Parent Trap','1998','Hallie Parker','Lindsay Lohan');
INSERT INTO Actors VALUES ('Parent Trap','1998','Annie James','Lindsay Lohan');
INSERT INTO Actors VALUES ('Forrest Gump','1994','Forrest Gump','Tom Hanks');
INSERT INTO Actors VALUES ('Schindlers List','1993','Oskar Schindler','Liam Neeson');
INSERT INTO Actors VALUES ('Titanic','1997','Jack Dawson','Leonardo DiCaprio');
INSERT INTO Actors VALUES ('Inception','2010','Cobb','Leonardo DiCaprio');
INSERT INTO Actors VALUES ('The Departed','2006','Billy','Leonardo DiCaprio');
INSERT INTO Actors VALUES ('The Shawshank Redemption','1994','Andy Dufresne','Tim Robbins');
INSERT INTO Actors VALUES ('Saving Private Ryan','1998', 'Capt. John H. Miller','Tom Hanks');



CREATE TABLE Awards (
    Title            varchar(80),
    Year         int,
    Award	 varchar(50),
    Result	 varchar(30)
);

INSERT INTO Awards VALUES ('Parent Trap','1998','Blockbuster Entertainment Awards, Favourite Female Newcomer','Nominated');
INSERT INTO Awards VALUES ('Forrest Gump','1994','Oscar, Best Actor','Won');
INSERT INTO Awards VALUES ('Forrest Gump','1994','Golden Globe, Best Actor','Won');
INSERT INTO Awards VALUES ('Schindlers List','1993','Oscar, Best Picture','Won');
INSERT INTO Awards VALUES ('Titanic','1997','Oscar, Best Picture','Won');
INSERT INTO Awards VALUES ('Inception','2010','Oscar, Best Motion Picture','Nominated');
INSERT INTO Awards VALUES ('The Departed','2006','Oscar, Best Achievement in Directing','Won');
INSERT INTO Awards VALUES ('The Shawshank Redemption','1994','Oscar, Best Actor','Nominated');
INSERT INTO Awards VALUES ('Saving Private Ryan','1998',