2L923hQs

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
4
5#################################################################################### Schema MovieRentalSystem
6drop SCHEMA IF EXISTS MovieRentalSystem;
7create SCHEMA IF NOT EXISTS MovieRentalSystem;
8USE MovieRentalSystem;
9
10#################################################################################### Table Movies
11drop table IF EXISTS Movies;
12create TABLE IF NOT EXISTS Movies (
13  ID INT NOT NULL AUTO_INCREMENT,
14  Title VARCHAR(70) NOT NULL,
15  ReleaseDate VARCHAR(70) NOT NULL,
16  RunTime VARCHAR(70) NOT NULL,
17  Rated VARCHAR(70) NOT NULL,
18  Ratings VARCHAR(70) NOT NULL,
19  Filename VARCHAR(70) NOT NULL,
20  Description TEXT NULL,
21  PRIMARY KEY (ID),
22  UNIQUE INDEX Title_UNIQUE (Title ASC) VISIBLE,
23  UNIQUE INDEX ID_UNIQUE (ID ASC) VISIBLE
24  );
25
26#################################################################################### Table Directors
27
28drop table IF EXISTS Directors;
29create TABLE IF NOT EXISTS Directors (
30  ID INT NOT NULL AUTO_INCREMENT,
31  Name VARCHAR(70) NOT NULL,
32  PRIMARY KEY (ID),
33  UNIQUE INDEX Name_UNIQUE (Name ASC) VISIBLE
34  );
35
36#################################################################################### Table Cast
37
38drop table IF EXISTS Cast;
39create TABLE IF NOT EXISTS Cast (
40  ID INT NOT NULL AUTO_INCREMENT,
41  Name VARCHAR(70) NOT NULL,
42  PRIMARY KEY (ID),
43  UNIQUE INDEX Name_UNIQUE (Name ASC) VISIBLE
44);
45
46#################################################################################### Table Genres
47
48drop table IF EXISTS Genres;
49create TABLE IF NOT EXISTS Genres (
50  ID INT NOT NULL AUTO_INCREMENT,
51  Genre VARCHAR(70) BINARY NOT NULL,
52  PRIMARY KEY (ID),
53  UNIQUE INDEX Genre_UNIQUE (Genre ASC) VISIBLE
54);
55
56#################################################################################### Table MovieDirectors
57drop table IF EXISTS MovieDirectors;
58create TABLE IF NOT EXISTS MovieDirectors (
59  MovieID INT NOT NULL,
60  DirectorID INT NOT NULL,
61  PRIMARY KEY (MovieID, DirectorID),
62  INDEX FK_Movie_Directors_Directors_idx (DirectorID ASC) VISIBLE,
63  INDEX FK_Movie_Directors_Movie_idx (MovieID ASC) VISIBLE,
64  CONSTRAINT FK_Movie_Directors_Movie
65    FOREIGN KEY (MovieID)
66    REFERENCES Movies (ID)
67    ON delete NO ACTION
68    ON update NO ACTION,
69  CONSTRAINT FK_Movie_Directors_Directors
70    FOREIGN KEY (DirectorID)
71    REFERENCES Directors (ID)
72    ON delete NO ACTION
73    ON update NO ACTION
74);
75
76#################################################################################### Table MovieGenres
77drop table IF EXISTS MovieGenres;
78create TABLE IF NOT EXISTS MovieGenres (
79  MovieID INT NOT NULL,
80  GenreID INT NOT NULL,
81  PRIMARY KEY (MovieID, GenreID),
82  INDEX FK_Movie_Genres_Genres_idx (GenreID ASC) VISIBLE,
83  INDEX FK_Movie_Genres_Movie_idx (MovieID ASC) VISIBLE,
84  CONSTRAINT FK_Movie_Genres_Movie
85    FOREIGN KEY (MovieID)
86    REFERENCES Movies (ID)
87    ON delete NO ACTION
88    ON update NO ACTION,
89  CONSTRAINT FK_Movie_Genres_Genres
90    FOREIGN KEY (GenreID)
91    REFERENCES Genres (ID)
92    ON delete NO ACTION
93    ON update NO ACTION
94);
95
96#################################################################################### Table Writers
97drop table IF EXISTS Writers;
98create TABLE IF NOT EXISTS Writers (
99  ID INT NOT NULL AUTO_INCREMENT,
100  Name VARCHAR(70) NULL,
101  PRIMARY KEY (ID),
102  UNIQUE INDEX Name_UNIQUE (Name ASC) VISIBLE
103);
104
105#################################################################################### Table MovieWriters
106drop table IF EXISTS MovieWriters;
107create TABLE IF NOT EXISTS MovieWriters (
108  MovieID INT NOT NULL,
109  WriterID INT NOT NULL,
110  PRIMARY KEY (MovieID, WriterID),
111  INDEX FK_Movie_Writers_Writers_idx (WriterID ASC) VISIBLE,
112  INDEX FK_Movie_Writers_Movie_idx (MovieID ASC) VISIBLE,
113  CONSTRAINT FK_Movie_Writers_Movie
114    FOREIGN KEY (MovieID)
115    REFERENCES Movies (ID)
116    ON delete NO ACTION
117    ON update NO ACTION,
118  CONSTRAINT FK_Movie_Writers_Writers
119    FOREIGN KEY (WriterID)
120    REFERENCES Writers (ID)
121    ON delete NO ACTION
122    ON update NO ACTION
123);
124
125#################################################################################### Table MovieCast
126drop table IF EXISTS MovieCast;
127create TABLE IF NOT EXISTS MovieCast (
128  MovieID INT NOT NULL,
129  CastID INT NOT NULL,
130  PRIMARY KEY (MovieID, CastID),
131  INDEX FK_Movie_Cast_Cast_idx (CastID ASC) VISIBLE,
132  INDEX FK_Movie_Cast_Movie_idx (MovieID ASC) VISIBLE,
133  CONSTRAINT FK_Movie_Cast_Movie
134    FOREIGN KEY (MovieID)
135    REFERENCES Movies (ID)
136    ON delete NO ACTION
137    ON update NO ACTION,
138  CONSTRAINT FK_Movie_Cast_Cast
139    FOREIGN KEY (CastID)
140    REFERENCES Cast (ID)
141    ON delete NO ACTION
142    ON update NO ACTION
143);
144
145#################################################################################### Table AccountTypes
146drop table IF EXISTS AccountTypes;
147create TABLE IF NOT EXISTS AccountTypes (
148  ID INT NOT NULL AUTO_INCREMENT,
149  Type VARCHAR(70) NOT NULL,
150  PRIMARY KEY (ID),
151  UNIQUE INDEX Type_UNIQUE (Type ASC) VISIBLE
152);
153
154#################################################################################### Table Customers
155drop table IF EXISTS Customers;
156create TABLE IF NOT EXISTS Customers (
157  ID INT NOT NULL AUTO_INCREMENT,
158  Username VARCHAR(70) NOT NULL,
159  AccountPassword VARCHAR(70) NULL,
160  AccountTypeID INT NOT NULL,
161  FirstName VARCHAR(70) NOT NULL,
162  MiddleName VARCHAR(70) NULL,
163  LastName VARCHAR(70) NOT NULL,
164  DateOfBirth VARCHAR(70) NULL,
165  Address VARCHAR(70) NOT NULL,
166  City VARCHAR(70) NOT NULL,
167  ZipCode VARCHAR(70) NOT NULL,
168  Phone VARCHAR(70) NULL,
169  PRIMARY KEY (ID, AccountTypeID),
170  UNIQUE INDEX Username_UNIQUE (Username ASC) VISIBLE,
171  UNIQUE INDEX ID_UNIQUE (ID ASC) VISIBLE,
172  INDEX FK_Customer_AccountType_idx (AccountTypeID ASC) VISIBLE,
173  CONSTRAINT FK_Customer_AccountType
174    FOREIGN KEY (AccountTypeID)
175    REFERENCES AccountTypes (ID)
176    ON delete NO ACTION
177    ON update NO ACTION
178);
179
180#################################################################################### Table Medias
181drop table IF EXISTS Medias;
182create TABLE IF NOT EXISTS Medias (
183  ID INT NOT NULL AUTO_INCREMENT,
184  Media ENUM('DVD', 'BLU-RAY') NULL,
185  PRIMARY KEY (ID)
186);
187
188#################################################################################### Table Rentals
189drop table IF EXISTS Rentals;
190create TABLE IF NOT EXISTS Rentals (
191  ID INT NOT NULL AUTO_INCREMENT,
192  CustomerID INT NOT NULL,
193  MediaID INT NOT NULL,
194  RentedOn VARCHAR(70) NOT NULL,
195  Returned TINYINT NOT NULL,
196  Held TINYINT DEFAULT 0,
197  ReturnedOn VARCHAR(70) NULL,
198  TotalDays INT NULL,
199  TotalCost FLOAT NULL,
200  PRIMARY KEY (ID, CustomerID, MediaID),
201  INDEX FK_Rental_Customer_idx (CustomerID ASC) VISIBLE,
202  INDEX FK_Rental_Media_idx (MediaID ASC) VISIBLE,
203  CONSTRAINT FK_Rental_Customer
204    FOREIGN KEY (CustomerID)
205    REFERENCES Customers (ID)
206    ON delete NO ACTION
207    ON update NO ACTION,
208  CONSTRAINT FK_Rental_Media
209    FOREIGN KEY (MediaID)
210    REFERENCES Medias (ID)
211    ON delete NO ACTION
212    ON update NO ACTION
213);
214
215####################################################################################
216drop table IF EXISTS MovieRental;
217create TABLE IF NOT EXISTS MovieRental (
218  MovieID INT NOT NULL,
219  RentalID INT NOT NULL,
220  PRIMARY KEY (MovieID, RentalID),
221  INDEX FK_Movie_Rental_Rental_idx (RentalID ASC) VISIBLE,
222  INDEX FK_Movie_Rental_Movie_idx (MovieID ASC) VISIBLE,
223  CONSTRAINT FK_Movie_Rental_Movie
224    FOREIGN KEY (MovieID)
225    REFERENCES Movies (ID)
226    ON delete NO ACTION
227    ON update NO ACTION,
228  CONSTRAINT FK_Movie_Rental_Rental
229    FOREIGN KEY (RentalID)
230    REFERENCES Rentals (ID)
231    ON delete NO ACTION
232    ON update NO ACTION
233);
234#################################################################################### SCHEMA END
235
236SET SQL_MODE=@OLD_SQL_MODE;
237SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
238SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
239
240#################################################################################### insert ACCOUNT TYPES
241insert into AccountTypes (Type) values ('USER');
242insert into AccountTypes (Type) values ('ADMIN');
243
244select * from AccountTypes;
245#################################################################################### insert CUSTOMERS
246INSERT INTO Customers (Username,AccountPassword,FirstName,MiddleName,LastName,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("dustindiaz", "dustin123", "Dustin", "A.", "Díaz", "1998-02-06", "4 Calle Aleli Urb. Round Hill", "Trujillo Alto", "00976", "787-478-2095", "2");
247INSERT INTO Customers (Username,AccountPassword,FirstName,MiddleName,LastName,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("root", "toor", "Root", "", "Account", "1860-02-06", "RA 0h 42m 44s | Dec +4° 6\' 9\"", "Andromeda Galaxy", "M3", "Radio Waves", "2");
248INSERT INTO Customers (Username,AccountPassword,FirstName,MiddleName,LastName,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("dustin123", "asd", 'Pedro', 'D.', 'Campo', '1996-2-06', "Villas De Rio Grande", 'Río Grande', '00745', '237-067-8900', "1");
249INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Clinton","Elvis","Holloway","Jayme Mann","ante","1992-12-13","P.O. Box 138, 5925 Odio. St.","Savona","4583","596-186-9323","1");
250INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Inga","Len","Barker","Ezra Mccray","volutpat","1997-07-07","744-5001 Eleifend Ave","Nogales","352006","285-770-7714","1");
251INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Hedley","Brett","Watkins","Forrest Mejia","sapien","1991-03-04","654-3869 Velit Street","Enines","785185","421-270-5443","1");
252INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Zena","Aurelia","Aguirre","Elton Kinney","vulputate","2001-11-22","P.O. Box 455, 4139 Lobortis Ave","Timkur","Z4229","792-657-3108","1");
253INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Lillian","Hillary","Love","Dominique Kinney","Nunc","1993-01-06","Ap #337-1384 Nullam Road","Geertruidenberg","245499","566-788-6198","1");
254INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Kaseem","Ivan","Chang","Phillip Moody","amet","2000-02-22","P.O. Box 316, 551 Tempus Rd.","McCallum","64439","241-235-2158","1");
255INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Eric","Quyn","Hess","Ivor Dale","in,","1993-03-12","7236 Fusce Rd.","Renlies","949183","186-415-5313","1");
256INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Daryl","Nita","Bates","Brady Moon","laoreet","1989-11-20","Ap #945-7550 Ut, Rd.","Kozhikode","025010","900-357-5113","1");
257INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Noble","Hu","Jacobson","Sybil Albert","non","2001-07-18","3596 Dolor, St.","Châlons-en-Champagne","3849","750-929-1086","1");
258INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Thaddeus","Teegan","Mcdonald","Aaron Patel","vitae,","1995-07-29","8258 Mauris. Road","Campobasso","92809","439-496-3567","1");
259INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Edward","Wallace","Sweeney","Piper Klein","hendrerit","2003-11-04","Ap #347-4389 Nec St.","Rochester","820496","240-782-9105","1");
260INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Courtney","Karyn","Glenn","Hilda Chang","bibendum","2001-05-10","7678 Quisque Road","Tiverton","432192","730-936-9541","1");
261INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Gregory","Lacota","Whitfield","Kai Crane","dolor.","2002-05-04","P.O. Box 206, 2574 Ac Avenue","Combarbalá","2710","819-598-0166","1");
262INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("David","Byron","Wynn","Gillian Moon","a,","1996-08-09","Ap #379-5260 Montes, Road","Herne","57494","702-918-0146","1");
263INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Kylee","Lilah","Strong","Nora Dickerson","ornare.","1996-05-12","4205 Mi Road","Giurdignano","5566","431-674-2080","1");
264INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Lisandra","Rajah","Mckay","Sydney Dorsey","faucibus","1995-04-14","P.O. Box 518, 3155 Euismod Av.","Norderstedt","73125","511-589-3384","1");
265INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Marvin","Arthur","Whitehead","Burton Maynard","Phasellus","1991-11-05","Ap #444-1229 Pharetra St.","Uijeongbu","2101","294-503-7380","1");
266INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Carlos","Leo","Lindsay","Haviva Trevino","mi","2000-09-07","Ap #165-2664 Tempus St.","Boise","844173","834-971-7943","1");
267INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Clementine","Ivana","Spence","Dante Coleman","felis","1999-11-15","Ap #800-9065 Tempus Avenue","Walsall","20616","902-100-1440","1");
268INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Norman","Lee","Kim","Latifah Sanford","Aliquam","1999-08-12","P.O. Box 701, 8542 Egestas, St.","Penticton","79766","578-409-9957","1");
269INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Emma","Halee","Kelly","Britanni Dennis","erat","2002-12-21","P.O. Box 741, 5042 Vitae, Road","Marzabotto","6008","874-811-4242","1");
270INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Hanae","Constance","Porter","Amir Garrison","Nunc","2004-09-30","P.O. Box 116, 9837 Aliquam St.","Thorembais-les-BŽguines","31090","518-434-5638","1");
271INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Lisandra","Geraldine","Prince","Quyn Stewart","enim,","1989-11-13","685-5455 Amet, St.","Körfez","Z5081","104-346-2036","1");
272INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Victoria","Sydney","Charles","Germane Sanchez","Proin","2003-07-06","Ap #562-576 Lorem Av.","Anzegem","60708","644-625-9653","1");
273INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Noah","Luke","Harvey","Susan Allen","nec","2002-12-26","Ap #832-1899 Non, Ave","Nadrin","395915","532-780-9113","1");
274INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Montana","Duncan","Brooks","Olga Dejesus","Mauris","1989-09-06","P.O. Box 943, 8980 Malesuada Av.","Paternopoli","71258","946-494-9844","1");
275INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Jaime","Nicholas","Vance","Brynne Rollins","lectus,","2003-08-26","4117 Ac Avenue","Kargopol","57623","439-767-6348","1");
276INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Zahir","Ori","Farmer","Hasad Carroll","Morbi","1991-02-04","P.O. Box 103, 4948 Donec Ave","San Isidro de El General","1577","895-690-8814","1");
277INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Jared","Peter","Burris","Rinah Osborn","mattis","1989-09-12","219 Tellus St.","Patos","Y3P 1V4","501-267-7506","1");
278INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Richard","Sybill","Robertson","Channing Soto","non","1990-10-08","P.O. Box 414, 411 Bibendum Rd.","Saravena","30059","522-750-0987","1");
279INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Jerry","Lareina","Madden","Macon Huff","ipsum.","2000-03-22","Ap #941-7482 Non Street","Gore","20406","250-464-6316","1");
280INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Montana","Craig","Shields","Dana Morrison","dolor","1990-10-18","161-9840 Dui Av.","Montoggio","45264-73645","522-233-9008","1");
281INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Emerald","Nehru","Wagner","Flavia Franklin","Donec","1994-12-29","Ap #405-607 Iaculis Ave","Koningshooikt","3713","608-461-5209","1");
282INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Ruth","Hedley","Ortega","Alana Chapman","eget","1999-05-16","952 Enim. Rd.","Ponti","66784","402-142-9977","1");
283INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Madaline","Madeson","Pace","Valentine Lewis","ante.","1992-12-23","Ap #156-7892 Nulla St.","Turbo","98-286","521-727-1864","1");
284INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("MacKensie","Kirby","Miranda","Nicholas Washington","ipsum.","1991-09-02","Ap #898-1132 Faucibus Rd.","Tarzo","3606","402-252-7783","1");
285INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Kennan","Louis","Brooks","Lareina Reyes","Integer","1994-03-20","Ap #452-6650 A Street","Saint-Malo","56447","377-496-0718","1");
286INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Rylee","Jack","Marshall","Petra Gibbs","Quisque","1990-10-11","Ap #908-1802 Vitae, Rd.","Palmira","H5G 3GV","587-672-2591","1");
287INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Alana","Richard","Dominguez","Oleg Hughes","lorem","1995-04-24","9813 Curabitur Rd.","Bacabal","1260","802-604-1317","1");
288INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Yuli","Juliet","Stokes","Nichole Figueroa","Integer","1989-11-22","Ap #262-7655 Elit, Road","Rhayader","1972","478-930-0669","1");
289INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Adria","Leo","Mcguire","Ashely Merritt","a","1999-08-10","526 Ipsum. St.","Ripalta Guerina","60700","316-899-7997","1");
290INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Candace","Gareth","Hardin","Shoshana Golden","cursus","2004-08-20","Ap #793-9374 Eu Road","Amelia","8903","875-377-9445","1");
291INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Sacha","Dahlia","Dodson","Diana Love","euismod","1990-07-09","8039 Quis Avenue","Torino","37728","196-405-9215","1");
292INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Edward","Chaim","Kramer","Sean Mccullough","arcu","1998-11-08","5814 Imperdiet, St.","Gießen","5850","895-508-4156","1");
293INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Beau","Chandler","Dorsey","Malik Williams","tempus","1998-07-30","648-9709 Vivamus Av.","Tramatza","66730","419-970-3187","1");
294INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Guinevere","Fay","Harmon","Dylan Fulton","Proin","2003-12-24","3581 Donec Av.","Gondiya","3244","233-648-4550","1");
295INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Leandra","Eaton","Gonzalez","Ivan Rich","erat","2002-08-08","Ap #372-4398 Tincidunt, Road","Branchon","993654","682-167-3254","1");
296INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Faith","Alden","Hester","Ryan Galloway","Donec","1999-02-23","851-7639 In Rd.","Porirua","47936","577-932-1832","1");
297INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Rooney","Victoria","Melendez","Nehru Lowe","consectetuer","2002-06-19","606-3472 Urna Ave","Picinisco","Z8703","171-952-7432","1");
298INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Darius","Blossom","Silva","Tamara Emerson","cursus","2000-03-02","P.O. Box 613, 9215 Arcu. St.","Sylvan Lake","44-635","447-273-9222","1");
299INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Tarik","Keegan","Porter","Bruce Mendoza","placerat","2002-10-19","Ap #904-9551 Aliquam St.","Dundee","70215","837-522-7700","1");
300INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Lynn","James","Chase","Joan Mcgee","vel","2004-11-12","131-8662 Class Road","Bowden","DC06 8XZ","313-209-4347","1");
301INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Joy","Fitzgerald","Holmes","Nero Hartman","lorem,","1994-03-22","Ap #120-9925 Eu Rd.","New Sarepta","44784-181","965-100-2986","1");
302INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Hamish","Reece","Maddox","Todd Rojas","condimentum","2002-07-15","Ap #625-3573 Egestas St.","Tando Muhammad Khan","97270","285-796-7883","1");
303INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Denise","Colin","Nichols","Carter Branch","tincidunt","1989-09-23","P.O. Box 486, 9981 Aenean Street","Pergola","5837","407-934-4397","1");
304INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Rhiannon","Christen","Roth","Violet Gregory","et","2003-08-04","P.O. Box 431, 8119 Sem Av.","South Dum Dum","16839","701-970-4761","1");
305INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Bianca","Isabelle","Hodges","Isabella Rose","consectetuer","1994-12-02","P.O. Box 980, 7265 Lacus St.","Guelph","825129","657-206-8602","1");
306INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Hillary","Nigel","Avery","Kaitlin Tillman","pede,","1998-05-06","2575 Magna. St.","Papudo","11947","772-568-2845","1");
307INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Basil","Cedric","Black","Abbot Bean","dapibus","1998-03-26","5323 Quis Av.","Curridabat","39252","131-275-2026","1");
308INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Brynne","Pearl","Holloway","Jane Koch","nec,","1989-12-24","P.O. Box 213, 1484 Massa Avenue","Burnaby","07976","670-454-0247","1");
309INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Stone","Ivory","Rivers","Colt Morris","eu","2001-10-02","591-6691 Mollis Rd.","Sitapur","44803","264-247-1110","1");
310INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Ronan","Xena","Clark","Larissa Christian","consectetuer","1995-02-23","Ap #916-4685 Interdum. Av.","Saint John","50415","625-825-0923","1");
311INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Kristen","Elvis","Travis","Xyla Le","mauris","1993-05-22","838-7386 Justo Avenue","Waardamme","9245","453-358-7468","1");
312INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Ahmed","Cyrus","Alford","Odysseus Vincent","odio,","2005-01-24","904-4865 Purus. Avenue","Geelong","83791","881-132-5898","1");
313INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Duncan","Petra","Madden","Rowan Lyons","convallis,","1996-04-09","9513 Sociis Avenue","Saint Louis","15692","453-363-1163","1");
314INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Lavinia","Amir","Yates","Allegra Newton","non,","1991-02-07","473-2349 Luctus St.","Garzón","44756","416-289-1179","1");
315INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Catherine","Teegan","Cervantes","Troy Levy","mi","2002-09-04","7939 Nec Rd.","Portsmouth","62624","627-159-7887","1");
316INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Ebony","Wing","Petty","Blair Horton","Aliquam","1996-07-27","P.O. Box 686, 199 Aliquam Rd.","Omaha","948867","666-106-4177","1");
317INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Xenos","Destiny","Perry","Ori Charles","Nullam","2002-07-05","383-9344 Donec St.","Ramenskoye","586212","672-978-1514","1");
318INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Yoshio","Cruz","Roberson","Mikayla Morrison","pharetra,","2000-02-20","Ap #582-8582 Magna. St.","Grimsby","711125","495-150-4306","1");
319INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Tarik","Trevor","Sparks","Quintessa Johnston","Nam","1999-02-03","P.O. Box 843, 2387 Arcu. Rd.","Blackwood","SR6 1BF","844-200-5594","1");
320INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Indigo","Sybill","Olsen","Quon Hansen","elementum,","1993-10-01","9118 Dapibus St.","C�te-Saint-Luc","067340","504-363-5329","1");
321INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Yoshi","Maile","Lee","Sydney Woodard","mauris","1998-06-16","993-1079 Id, Ave","Rekem","731711","533-727-8623","1");
322INSERT INTO Customers (FirstName,MiddleName,LastName,Username,AccountPassword,DateOfBirth,Address,City,ZipCode,Phone,AccountTypeID) VALUES ("Delilah","Samantha","Burke","Ivor Daniels","ut,","1998-12-24","Ap #984-8209 Suspendisse Rd.","Martelange","04976","549-984-4029","1");
323
324SELECT * FROM Customers;
325
326#################################################################################### INSERT Movies
327
328INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Aliens','1986-08-29','2h 17m','15','8.3/10','524650ab-d460-4aab-aa26-8dbad70fbf99.jpg'); #1
329INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('One Flew Over the Cuckoo\'s Nest','1976-02-26','2h 13m','X','8.7/10','2d7e201b-e4d8-41ef-8605-45e7a0f4096f.jpg'); #2
330INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Kid','2019-03-08','1h 8m','U','8.3/10','bafb7b28-203d-48fb-b7cd-781227eba566.jpg'); #3
331INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Life Is Beautiful','1999-02-12','1h 56m','PG','8.6/10','41a652d1-da42-4c5b-9ebd-827116cd962a.jpg'); #4
332INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Princess Mononoke','2001-10-19','2h 14m','PG','8.4/10','ed1d29f2-b218-4449-b89b-8b671d6a44cd.jpg'); #5
333INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Witness for the Prosecution','1958-02-06','1h 56m','U','8.4/10','be1ff571-619e-4317-9ccd-0666a8f6b2b7.jpg'); #6
334INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Usual Suspects','1995-08-25','1h 46m','18','8.5/10','0de6cf4d-907f-43bc-bee3-1ed03b522411.jpg'); #7
335INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Pianist','2003-01-24','2h 30m','15','8.5/10','1745f694-8b2e-4450-8333-c1102e4dc0ed.jpg'); #8
336INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Avengers: Infinity War','2018-04-26','2h 29m','12A','8.5/10','85b8387f-ff87-4863-bc1c-15a923d9c165.jpg'); #9
337INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Lord of the Rings: The Return of the King','2003-12-17','3h 21m','12A','8.9/10','33faa3af-fd4f-4d55-9b4b-085911d0871d.jpg'); #10
338INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Amélie','2001-10-05','2h 2m','15','8.3/10','b9de665a-c88d-4b7e-93bf-5f279549bab0.jpg'); #11
339INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Matrix','1999-06-11','2h 16m','15','8.7/10','ff9db5fb-faa6-4fe6-8e16-94516fdce052.jpg'); #12
340INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('2001: A Space Odyssey','1968-05-12','2h 29m','U','8.3/10','70336f12-8c83-4792-b962-52568dedd1bb.jpg'); #13
341INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Lord of the Rings: The Two Towers','2002-12-18','2h 59m','12A','8.7/10','b5b3df95-5ec5-4f91-bbfc-22c4738a5a3b.jpg'); #14
342INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Star Wars: Episode V - The Empire Strikes Back','1980-05-21','2h 4m','U','8.7/10','1ade8e67-4091-4b29-88e0-380ba650f470.jpg'); #15
343INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Apocalypse Now','1979-12-19','2h 27m','X','8.4/10','a663f66f-5515-4ee1-9e76-a87362e872e6.jpg'); #16
344INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('North by Northwest','1959-11-20','2h 16m','A','8.3/10','47facc3b-7e8d-4822-afd6-a8e43f95b349.jpg'); #17
345INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Shining','1980-10-05','2h 26m','15','8.4/10','c5fcfdba-8b8c-43ee-aaa3-d7564d744c02.jpg'); #18
346INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('3 Idiots','2009-12-24','2h 50m','12A','8.4/10','6a2f58fb-3f63-44e8-956b-e77ed6015db0.jpg'); #19
347INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Avengers: Endgame','2019-04-25','3h 1m','12A','8.4/10','0943d9ca-b39d-43b4-96cb-0e77ade3a2db.jpg'); #20
348INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Once Upon a Time in America','1984-10-05','3h 49m','R','8.4/10','8b38a0b5-922f-47b4-b404-b3fdd678a168.jpg'); #21
349INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Dark Knight','2008-07-24','2h 32m','12A','9/10','540eb947-ec80-4619-871a-2fa05d06d011.jpg'); #22
350INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Untouchable','2012-09-21','1h 52m','15','8.5/10','13d5ae24-9d08-4f23-9416-aaf013b884ae.jpg'); #23
351INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Casablanca','1943-01-23','1h 42m','U','8.5/10','5b543f92-3041-437c-b359-df2f35940de6.jpg'); #24
352INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Vertigo','1958-05-22','2h 8m','A','8.3/10','b8a5d759-67af-4b72-af8d-4a05566ecc82.jpg'); #25
353INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Interstellar','2014-11-07','2h 49m','12A','8.6/10','d1266c0e-756f-4f8c-85f5-e59d9f199e4c.jpg'); #26
354INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Harakiri','1964-08-04','2h 13m','X','8.7/10','2430cb2e-ecac-49c5-bd01-7c9722332f2f.jpg'); #27
355INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Star Wars: Episode IV - A New Hope','1978-01-29','2h 1m','U','8.6/10','d33cad96-355b-4ff0-85be-cd53f339cbf8.jpg'); #28
356INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Good Will Hunting','1998-03-06','2h 6m','15','8.3/10','be856e2d-acb3-4603-b754-c7e14b8d0630.jpg'); #29
357INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Dangal','2016-12-22','2h 41m','PG','8.4/10','07ac66d8-b173-4999-8570-b496d894eb01.jpg'); #30
358INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('A Clockwork Orange','1972-01-13','2h 16m','X','8.3/10','943ff360-b13e-4853-9134-fe92787392cc.jpg'); #31
359INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Eternal Sunshine of the Spotless Mind','2004-04-30','1h 48m','15','8.3/10','734597ed-7956-492e-80fe-ec273c5dd691.jpg'); #32
360INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Coco','2018-01-19','1h 45m','PG','8.4/10','0b5161bc-378e-4f02-a5f9-ce95fc2c0714.jpg'); #33
361INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Like Stars on Earth','2007-12-21','2h 45m','PG','8.4/10','c1fbc338-e4fa-4374-a3d5-f063c62ba42d.jpg'); #34
362INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('12 Angry Men','1957-04-10','1h 36m','U','8.9/10','9d9bd45b-2bbb-475b-9f96-bb02e3dd8024.jpg'); #35
363INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Departed','2006-10-06','2h 31m','18','8.5/10','02a06250-c5be-40bf-baf5-07ebb12883ef.jpg'); #36
364INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Inception','2010-07-16','2h 28m','12A','8.8/10','b3567e47-d596-4694-aa5a-8737f6a1dcd1.jpg'); #37
365INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Hunt','2013-01-10','1h 55m','15','8.3/10','dcf41b10-c8bc-4614-bfc4-5c30816ca7b7.jpg'); #38
366INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Requiem for a Dream','2001-01-19','1h 42m','18','8.3/10','bb58c5fe-d5f4-4a94-b77c-5fec219902ee.jpg'); #39
367INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('WALL·E','2008-07-18','1h 38m','U','8.4/10','e00a101d-4f02-4416-a14b-1b6c3e7e9d20.jpg'); #40
368INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('It\'s a Wonderful Life','1947-01-07','2h 10m','U','8.6/10','275723de-d59d-4992-a25d-14d12c40dbe9.jpg'); #41
369INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Alien','1979-09-06','1h 57m','X','8.4/10','07012bc6-8a0e-4ccb-b568-1a92bf675a3c.jpg'); #42
370INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('American History X','1999-03-26','1h 59m','18','8.5/10','2068fdc9-a33e-4db3-9943-2c24f3e1448c.jpg'); #43
371INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Toy Story','1996-03-22','1h 21m','PG','8.3/10','785fb93f-8149-4483-90c7-765ee031e5b2.jpg'); #44
372INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Seven Samurai','1956-11-19','3h 27m','A','8.6/10','fbb34e62-7ea5-47cd-ae6b-b89883dab0da.jpg'); #45
373INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Modern Times','1936-02-11','1h 27m','U','8.5/10','448bcddc-6fa6-4dc5-b3b2-1a78d1258871.jpg'); #46
374INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Green Mile','2000-03-03','3h 9m','18','8.6/10','a20e9d45-b698-463f-9950-5c627ff4d649.jpg'); #47
375INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Schindler\'s List','1994-02-18','3h 15m','15','8.9/10','d7d0b229-d83e-45d8-a392-998acc36d2e4.jpg'); #48
376INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Rear Window','1954-11-15','1h 52m','A','8.4/10','2e8fd3e6-b268-453a-804e-fb31fbd602f2.jpg'); #49
377INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Full Metal Jacket','1987-09-11','1h 56m','15','8.3/10','fe35e5b9-dba7-4c18-8dc5-46ccebf5cb6c.jpg'); #50
378INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('City Lights','1931-03-07','1h 27m','U','8.5/10','eadeb9d4-47cf-4e2e-a630-6f1edc471a55.jpg'); #51
379INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Great Dictator','1941-03-07','2h 5m','U','8.4/10','08da4760-c681-43c4-9d24-645063d30d18.jpg'); #52
380INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('M','1931-08-31','1h 39m','A','8.3/10','b948987e-a2be-40c7-953f-19d3099b12d9.jpg'); #53
381INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Grave of the Fireflies','1989-04-07','1h 29m','12A','8.5/10','40943a9f-8368-400d-a37e-b57212faaa81.jpg'); #54
382INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Silence of the Lambs','1991-05-31','1h 58m','18','8.6/10','3b7c0814-b084-4b44-a091-131842d926fb.jpg'); #55
383INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Gladiator','2000-05-12','2h 35m','15','8.5/10','f6fc68dc-40e5-4ee7-be73-b6bb9deb6c07.jpg'); #56
384INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Back to the Future','1985-12-04','1h 56m','PG','8.5/10','2340d6dd-9d37-46a5-a36d-efb729a34293.jpg'); #57
385INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Braveheart','1995-09-08','2h 58m','15','8.3/10','7a2724c7-1441-4ae9-a244-dad483a65919.jpg'); #58
386INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Leon','1995-02-03','1h 50m','18','8.5/10','61c8edaf-928f-41f1-ae10-7ef0460c2a97.jpg'); #59
387INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Inglourious Basterds','2009-08-19','2h 33m','18','8.3/10','402caf09-b956-433f-84d4-fa1270bdc352.jpg'); #60
388INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Shawshank Redemption','1995-02-17','2h 22m','15','9.3/10','8c092028-6cd4-4ce5-a3e1-da67c9358493.jpg'); #61
389INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Oldboy','2004-10-15','2h','18','8.4/10','4c67d2df-f2fc-4a62-baed-ba6c7d651b2a.jpg'); #62
390INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('City of God','2003-01-03','2h 10m','18','8.6/10','889b2f93-7d0f-447e-88b6-1c0124fc05c0.jpg'); #63
391INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Forrest Gump','1994-10-07','2h 22m','12','8.8/10','10024a21-4748-4b90-8c48-da25e5131bf1.jpg'); #64
392INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Reservoir Dogs','1993-01-15','1h 39m','18','8.3/10','a863903e-5f54-4f1a-aaa7-5acaeeb97193.jpg'); #65
393INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Lord of the Rings: The Fellowship of the Ring','2001-12-19','2h 58m','PG','8.8/10','8e27f219-759a-401b-ad14-698c21d68398.jpg'); #66
394INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Joker','2019-10-04','2h 2m','15','8.5/10','fbf98850-c11c-4b18-b4d0-0227621d6368.jpg'); #67
395INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Memento','2000-10-20','1h 53m','15','8.4/10','88e5c7ce-29cb-49af-b2e7-3722822772e2.jpg'); #68
396INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Prestige','2006-11-10','2h 10m','12A','8.5/10','7c05b6fb-097a-48ea-a574-b94b628463b3.jpg'); #69
397INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Your Name.','2016-11-18','1h 46m','12A','8.4/10','1b1f9a1e-67b9-4c28-91aa-82c6aaea1366.jpg'); #70
398INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('American Beauty','2000-02-04','2h 2m','18','8.3/10','7e74f813-e5d9-4371-8d65-860f0637d692.jpg'); #71
399INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Lives of Others','2007-04-13','2h 17m','15','8.4/10','0ec3509d-7e33-4a63-9c3f-86cb8b6817aa.jpg'); #72
400INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Saving Private Ryan','1998-09-11','2h 49m','15','8.6/10','27425015-1ec3-40c1-bb27-b33b62faa59b.jpg'); #73
401INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Raiders of the Lost Ark','1981-07-30','1h 55m','A','8.4/10','5b02cfdc-00c2-4a2a-98a7-cef0beafcb41.jpg'); #74
402INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Once Upon a Time in the West','1969-08-31','2h 45m','AA','8.5/10','99f82a2a-3ef1-46e9-913d-856de7e6c0ae.jpg'); #75
403INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Godfather','1972-08-24','2h 55m','X','9.2/10','dd655f46-0f52-4293-91f5-f2924684601f.jpg'); #76
404INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Terminator 2: Judgment Day','1991-08-16','2h 17m','R','8.5/10','57dc000a-d7ce-4f2d-9d7b-93bab75bef65.jpg'); #77
405INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Lion King','1994-10-07','1h 28m','U','8.5/10','4db6809f-f697-4822-aedb-8ccec95d61fd.jpg'); #78
406INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Star Wars: Episode VI - Return of the Jedi','1983-06-02','2h 11m','U','8.3/10','b61bc901-d119-4f04-8baa-ab9dab69b3b3.jpg'); #79
407INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Seven','1996-01-05','2h 7m','18','8.6/10','73fe9d63-ca9c-46d1-94e6-08f825f4fac2.jpg'); #80
408INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Sunset Blvd.','1950-09-29','1h 50m','PG','8.4/10','59d839c0-3f25-4ee5-ab2b-6d65fd728886.jpg'); #81
409INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Spirited Away','2003-09-12','2h 5m','PG','8.6/10','f7effd23-7afe-4df4-8803-63f6eedc9608.jpg'); #82
410INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Pulp Fiction','1994-10-21','2h 34m','18','8.9/10','78a3a07a-fe5d-48d6-a33c-6dbc9029f235.jpg'); #83
411INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Snatch','2000-09-01','1h 42m','18','8.3/10','d1790c09-dd35-4367-bd8e-d3ce1cd906b7.jpg'); #84
412INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Fight Club','1999-11-12','2h 19m','18','8.8/10','d4ed9d56-4c44-4e06-929e-ca603b55115d.jpg'); #85
413INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Psycho','1960-09-15','1h 49m','X','8.5/10','0c91a115-00fd-4ecb-bc68-017c47d8cca6.jpg'); #86
414INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Citizen Kane','1942-01-24','1h 59m','A','8.3/10','5a1b704a-0bea-4d3b-929a-76f5b372227c.jpg'); #87
415INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Das Boot','1982-02-10','2h 29m','AA','8.3/10','d188a74e-e1c4-4321-a6a4-ba700deec845.jpg'); #88
416INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Paths of Glory','1957-12-20','1h 28m','PG','8.4/10','35af5639-b311-40e8-aefa-38b11e41481f.jpg'); #89
417INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Spider-Man: Into the Spider-Verse','2018-12-12','1h 57m','PG','8.4/10','abe74a16-85d2-4120-9579-2280c5e3ce27.jpg'); #90
418INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Amadeus','1985-01-17','2h 40m','R','8.3/10','26e02539-c29b-41d1-9e0d-5d6bb2aa0871.jpg'); #91
419INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Django Unchained','2013-01-18','2h 45m','18','8.4/10','162de5a1-08e2-4a5b-b864-f1c175193f04.jpg'); #92
420INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Good, the Bad and the Ugly','1967-12-29','2h 28m','X','8.8/10','f29ef06e-5c5e-4453-afee-93452d721664.jpg'); #93
421INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Goodfellas','1990-10-26','2h 26m','18','8.7/10','775d2bcb-1438-4846-ab7b-12b444529b02.jpg'); #94
422INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Whiplash','2015-01-16','1h 46m','15','8.5/10','d262e2ab-8a2a-4879-94e4-58217369cd4c.jpg'); #95
423INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Godfather: Part II','1975-05-15','3h 22m','X','9/10','a55ceea0-feb8-4dc4-9696-da5409954d85.jpg'); #96
424INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Parasite','2020-02-07','2h 12m','15','8.6/10','f8efd07e-b712-48fe-9ef8-1e2af9acf211.jpg'); #97
425INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb','1964-01-29','1h 35m','A','8.4/10','8c79aad0-c6c4-467c-b2d9-b2702df9a62a.jpg'); #98
426INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('Cinema Paradiso','1990-02-23','2h 35m','PG','8.5/10','bf573bf3-9a0b-4f04-9421-8b2869ff146c.jpg'); #99
427INSERT INTO Movies (Title,ReleaseDate,RunTime,Rated,Ratings,Filename) VALUES ('The Dark Knight Rises','2012-07-20','2h 44m','12A','8.4/10','dcc63c2b-c3d6-4bde-9897-6428be67a28b.jpg'); #100
428
429UPDATE Movies SET Description = 'Two imprisoned men bond over a number of years, finding solace and eventual redemption through acts of common decency.' WHERE ID = 61;
430UPDATE Movies SET Description = 'The aging patriarch of an organized crime dynasty transfers control of his clandestine empire to his reluctant son.' WHERE ID = 76;
431UPDATE Movies SET Description = 'When the menace known as the Joker wreaks havoc and chaos on the people of Gotham, Batman must accept one of the greatest psychological and physical tests of his ability to fight injustice.' WHERE ID = 22;
432UPDATE Movies SET Description = 'The early life and career of Vito Corleone in 1920s New York City is portrayed, while his son, Michael, expands and tightens his grip on the family crime syndicate.' WHERE ID = 96;
433UPDATE Movies SET Description = 'Gandalf and Aragorn lead the World of Men against Sauron\'s army to draw his gaze from Frodo and Sam as they approach Mount Doom with the One Ring.' WHERE ID = 10;
434UPDATE Movies SET Description = 'The lives of two mob hitmen, a boxer, a gangster and his wife, and a pair of diner bandits intertwine in four tales of violence and redemption.' WHERE ID = 83;
435UPDATE Movies SET Description = 'In German-occupied Poland during World War II, industrialist Oskar Schindler gradually becomes concerned for his Jewish workforce after witnessing their persecution by the Nazis.' WHERE ID = 48;
436UPDATE Movies SET Description = 'A jury holdout attempts to prevent a miscarriage of justice by forcing his colleagues to reconsider the evidence.' WHERE ID = 35;
437UPDATE Movies SET Description = 'A thief who steals corporate secrets through the use of dream-sharing technology is given the inverse task of planting an idea into the mind of a C.E.O.' WHERE ID = 37;
438UPDATE Movies SET Description = 'An insomniac office worker and a devil-may-care soapmaker form an underground fight club that evolves into something much, much more.' WHERE ID = 85;
439UPDATE Movies SET Description = 'A meek Hobbit from the Shire and eight companions set out on a journey to destroy the powerful One Ring and save Middle-earth from the Dark Lord Sauron.' WHERE ID = 66;
440UPDATE Movies SET Description = 'The presidencies of Kennedy and Johnson, the events of Vietnam, Watergate, and other historical events unfold through the perspective of an Alabama man with an IQ of 75, whose only desire is to be reunited with his childhood sweetheart.' WHERE ID = 64;
441UPDATE Movies SET Description = 'A bounty hunting scam joins two men in an uneasy alliance against a third in a race to find a fortune in gold buried in a remote cemetery.' WHERE ID = 93;
442UPDATE Movies SET Description = 'While Frodo and Sam edge closer to Mordor with the help of the shifty Gollum, the divided fellowship makes a stand against Sauron\'s new ally, Saruman, and his hordes of Isengard.' WHERE ID = 14;
443UPDATE Movies SET Description = 'A computer hacker learns from mysterious rebels about the true nature of his reality and his role in the war against its controllers.' WHERE ID = 12;
444UPDATE Movies SET Description = 'The story of Henry Hill and his life in the mob, covering his relationship with his wife Karen Hill and his mob partners Jimmy Conway and Tommy DeVito in the Italian-American crime syndicate.' WHERE ID = 94;
445UPDATE Movies SET Description = 'After the Rebels are brutally overpowered by the Empire on the ice planet Hoth, Luke Skywalker begins Jedi training with Yoda, while his friends are pursued by Darth Vader and a bounty hunter named Boba Fett all over the galaxy.' WHERE ID = 15;
446UPDATE Movies SET Description = 'A criminal pleads insanity and is admitted to a mental institution, where he rebels against the oppressive nurse and rallies up the scared patients.' WHERE ID = 2;
447UPDATE Movies SET Description = 'When a ronin requesting seppuku at a feudal lord\'s palace is told of the brutal suicide of another ronin who previously visited, he reveals how their pasts are intertwined - and in doing so challenges the clan\'s integrity.' WHERE ID = 27;
448UPDATE Movies SET Description = 'A poor family, the Kims, con their way into becoming the servants of a rich family, the Parks. But their easy life gets complicated when their deception is threatened with exposure.' WHERE ID = 97;
449UPDATE Movies SET Description = 'A team of explorers travel through a wormhole in space in an attempt to ensure humanity\'s survival.' WHERE ID = 26;
450UPDATE Movies SET Description = 'In the slums of Rio, two kids\' paths diverge as one struggles to become a photographer and the other a kingpin.' WHERE ID = 63;
451UPDATE Movies SET Description = 'During her family\'s move to the suburbs, a sullen 10-year-old girl wanders into a world ruled by gods, witches, and spirits, and where humans are changed into beasts.' WHERE ID = 82;
452UPDATE Movies SET Description = 'Following the Normandy Landings, a group of U.S. soldiers go behind enemy lines to retrieve a paratrooper whose brothers have been killed in action.' WHERE ID = 73;
453UPDATE Movies SET Description = 'The lives of guards on Death Row are affected by one of their charges: a black man accused of child murder and rape, yet who has a mysterious gift.' WHERE ID = 47;
454UPDATE Movies SET Description = 'When an open-minded Jewish librarian and his son become victims of the Holocaust, he uses a perfect mixture of will, humor, and imagination to protect his son from the dangers around their camp.' WHERE ID = 4;
455UPDATE Movies SET Description = 'Two detectives, a rookie and a veteran, hunt a serial killer who uses the seven deadly sins as his motives.' WHERE ID = 80;
456UPDATE Movies SET Description = 'A young F.B.I. cadet must receive the help of an incarcerated and manipulative cannibal killer to help catch another serial killer, a madman who skins his victims.' WHERE ID = 55;
457UPDATE Movies SET Description = 'Luke Skywalker joins forces with a Jedi Knight, a cocky pilot, a Wookiee and two droids to save the galaxy from the Empire\'s world-destroying battle station, while also attempting to rescue Princess Leia from the mysterious Darth Vader.' WHERE ID = 28;
458UPDATE Movies SET Description = 'A poor village under attack by bandits recruits seven unemployed samurai to help them defend themselves.' WHERE ID = 45;
459UPDATE Movies SET Description = 'An angel is sent from Heaven to help a desperately frustrated businessman by showing him what life would have been like if he had never existed.' WHERE ID = 41;
460UPDATE Movies SET Description = 'In Gotham City, mentally troubled comedian Arthur Fleck is disregarded and mistreated by society. He then embarks on a downward spiral of revolution and bloody crime. This path brings him face-to-face with his alter-ego: the Joker.' WHERE ID = 67;
461UPDATE Movies SET Description = 'The Avengers and their allies must be willing to sacrifice all in an attempt to defeat the powerful Thanos before his blitz of devastation and ruin puts an end to the universe.' WHERE ID = 9;
462UPDATE Movies SET Description = 'A promising young drummer enrolls at a cut-throat music conservatory where his dreams of greatness are mentored by an instructor who will stop at nothing to realize a student\'s potential.' WHERE ID = 95;
463UPDATE Movies SET Description = 'After he becomes a quadriplegic from a paragliding accident, an aristocrat hires a young man from the projects to be his caregiver.' WHERE ID = 23;
464UPDATE Movies SET Description = 'After a tragic accident, two stage magicians engage in a battle to create the ultimate illusion while sacrificing everything they have to outwit each other.' WHERE ID = 69;
465UPDATE Movies SET Description = 'An undercover cop and a mole in the police attempt to identify each other while infiltrating an Irish gang in South Boston.' WHERE ID = 36;
466UPDATE Movies SET Description = 'A Polish Jewish musician struggles to survive the destruction of the Warsaw ghetto of World War II.' WHERE ID = 8;
467UPDATE Movies SET Description = 'A former Roman General sets out to exact vengeance against the corrupt emperor who murdered his family and sent him into slavery.' WHERE ID = 56;
468UPDATE Movies SET Description = 'A former neo-nazi skinhead tries to prevent his younger brother from going down the same wrong path that he did.' WHERE ID = 43;
469UPDATE Movies SET Description = 'A sole survivor tells of the twisty events leading up to a horrific gun battle on a boat, which began when five criminals met at a seemingly random police lineup.' WHERE ID = 7;
470UPDATE Movies SET Description = 'Mathilda, a 12-year-old girl, is reluctantly taken in by Léon, a professional assassin, after her family is murdered. An unusual relationship forms as she becomes his protégée and learns the assassin\'s trade.' WHERE ID = 59;
471UPDATE Movies SET Description = 'A Lion cub crown prince is tricked by a treacherous uncle into thinking he caused his father\'s death and flees into exile in despair, only to learn in adulthood his identity and his responsibilities.' WHERE ID = 78;
472UPDATE Movies SET Description = 'A cyborg, identical to the one who failed to kill Sarah Connor, must now protect her teenage son, John Connor, from a more advanced and powerful cyborg.' WHERE ID = 77;
473UPDATE Movies SET Description = 'A filmmaker recalls his childhood when falling in love with the pictures at the cinema of his home village and forms a deep friendship with the cinema\'s projectionist.' WHERE ID = 99;
474UPDATE Movies SET Description = 'A young boy and his little sister struggle to survive in Japan during World War II.' WHERE ID = 54;
475UPDATE Movies SET Description = 'Marty McFly, a 17-year-old high school student, is accidentally sent thirty years into the past in a time-traveling DeLorean invented by his close friend, the eccentric scientist Doc Brown.' WHERE ID = 57;
476UPDATE Movies SET Description = 'A mysterious stranger with a harmonica joins forces with a notorious desperado to protect a beautiful widow from a ruthless assassin working for the railroad.' WHERE ID = 75;
477UPDATE Movies SET Description = 'A Phoenix secretary embezzles forty thousand dollars from her employer\'s client, goes on the run, and checks into a remote motel run by a young man under the domination of his mother.' WHERE ID = 86;
478UPDATE Movies SET Description = 'A cynical American expatriate struggles to decide whether or not he should help his former lover and her fugitive husband escape French Morocco.' WHERE ID = 24;
479UPDATE Movies SET Description = 'The Tramp struggles to live in modern industrial society with the help of a young homeless woman.' WHERE ID = 46;
480UPDATE Movies SET Description = 'With the aid of a wealthy erratic tippler, a dewy-eyed tramp who has fallen in love with a sightless flower girl accumulates money to be able to help her medically.' WHERE ID = 51;
481UPDATE Movies SET Description = 'Two strangers find themselves linked in a bizarre way. When a connection forms, will distance be the only thing to keep them apart?' WHERE ID = 70;
482UPDATE Movies SET Description = 'Former wrestler Mahavir Singh Phogat and his two wrestler daughters struggle towards glory at the Commonwealth Games in the face of societal oppression.' WHERE ID = 30;
483UPDATE Movies SET Description = 'Teen Miles Morales becomes Spider-Man of his reality, crossing his path with five counterparts from other dimensions to stop a threat for all realities.' WHERE ID = 90;
484UPDATE Movies SET Description = 'After the devastating events of Avengers: Infinity War (2018), the universe is in ruins. With the help of remaining allies, the Avengers assemble once more in order to reverse Thanos\' actions and restore balance to the universe.' WHERE ID = 20;
485UPDATE Movies SET Description = 'Aspiring musician Miguel, confronted with his family\'s ancestral ban on music, enters the Land of the Dead to find his great-great-grandfather, a legendary singer.' WHERE ID = 33;
486UPDATE Movies SET Description = 'With the help of a German bounty hunter, a freed slave sets out to rescue his wife from a brutal Mississippi plantation owner.' WHERE ID = 92;
487UPDATE Movies SET Description = 'Eight years after the Joker\'s reign of anarchy, Batman, with the help of the enigmatic Catwoman, is forced from his exile to save Gotham City from the brutal guerrilla terrorist Bane.' WHERE ID = 100;
488UPDATE Movies SET Description = 'Two friends are searching for their long lost companion. They revisit their college days and recall the memories of their friend who inspired them to think differently, even as the rest of the world called them idiots.' WHERE ID = 19;
489UPDATE Movies SET Description = 'An eight-year-old boy is thought to be a lazy trouble-maker, until the new art teacher has the patience and compassion to discover the real problem behind his struggles in school.' WHERE ID = 34;
490UPDATE Movies SET Description = 'In the distant future, a small waste-collecting robot inadvertently embarks on a space journey that will ultimately decide the fate of mankind.' WHERE ID = 40;
491UPDATE Movies SET Description = 'In 1984 East Berlin, an agent of the secret police, conducting surveillance on a writer and his lover, finds himself becoming increasingly absorbed by their lives.' WHERE ID = 72;
492UPDATE Movies SET Description = 'After being kidnapped and imprisoned for fifteen years, Oh Dae-Su is released, only to find that he must find his captor in five days.' WHERE ID = 62;
493UPDATE Movies SET Description = 'A man with short-term memory loss attempts to track down his wife\'s murderer.' WHERE ID = 68;
494UPDATE Movies SET Description = 'On a journey to find the cure for a Tatarigami\'s curse, Ashitaka finds himself in the middle of a war between the forest gods and Tatara, a mining colony. In this quest he also meets San, the Mononoke Hime.' WHERE ID = 5;
495UPDATE Movies SET Description = 'A former Prohibition-era Jewish gangster returns to the Lower East Side of Manhattan over thirty years later, where he once again must confront the ghosts and regrets of his old life.' WHERE ID = 21;
496UPDATE Movies SET Description = 'In 1936, archaeologist and adventurer Indiana Jones is hired by the U.S. government to find the Ark of the Covenant before Adolf Hitler\'s Nazis can obtain its awesome powers.' WHERE ID = 74;
497UPDATE Movies SET Description = 'A family heads to an isolated hotel for the winter where a sinister presence influences the father into violence, while his psychic son sees horrific forebodings from both past and future.' WHERE ID = 18;
498UPDATE Movies SET Description = 'A U.S. Army officer serving in Vietnam is tasked with assassinating a renegade Special Forces Colonel who sees himself as a god.' WHERE ID = 16;
499UPDATE Movies SET Description = 'After a space merchant vessel receives an unknown transmission as a distress call, one of the crew is attacked by a mysterious life form and they soon realize that its life cycle has merely begun.' WHERE ID = 42;
500UPDATE Movies SET Description = 'An insane general triggers a path to nuclear holocaust that a War Room full of politicians and generals frantically tries to stop.' WHERE ID = 98;
501UPDATE Movies SET Description = 'A veteran British barrister must defend his client in a murder trial that has surprise after surprise.' WHERE ID = 6;
502UPDATE Movies SET Description = 'After refusing to attack an enemy position, a general accuses the soldiers of cowardice and their commanding officer must defend them.' WHERE ID = 89;
503UPDATE Movies SET Description = 'A wheelchair-bound photographer spies on his neighbors from his apartment window and becomes convinced one of them has committed murder.' WHERE ID = 49;
504UPDATE Movies SET Description = 'A screenwriter develops a dangerous relationship with a faded film star determined to make a triumphant return.' WHERE ID = 81;
505UPDATE Movies SET Description = 'Dictator Adenoid Hynkel tries to expand his empire while a poor Jewish barber tries to avoid persecution from Hynkel\'s regime.' WHERE ID = 52;
506UPDATE Movies SET Description = 'A teacher lives a lonely life, all the while struggling over his son\'s custody. His life slowly gets better as he finds love and receives good news from his son, but his new luck is about to be brutally shattered by an innocent little lie.' WHERE ID = 38;
507UPDATE Movies SET Description = 'In Nazi-occupied France during World War II, a plan to assassinate Nazi leaders by a group of Jewish U.S. soldiers coincides with a theatre owner\'s vengeful plans for the same.' WHERE ID = 60;
508UPDATE Movies SET Description = 'When their relationship turns sour, a couple undergoes a medical procedure to have each other erased from their memories.' WHERE ID = 32;
509UPDATE Movies SET Description = 'Amélie is an innocent and naive girl in Paris with her own sense of justice. She decides to help those around her and, along the way, discovers love.' WHERE ID = 11;
510UPDATE Movies SET Description = 'Unscrupulous boxing promoters, violent bookmakers, a Russian gangster, incompetent amateur robbers and supposedly Jewish jewelers fight to track down a priceless stolen diamond.' WHERE ID = 84;
511UPDATE Movies SET Description = 'The drug-induced utopias of four Coney Island people are shattered when their addictions run deep.' WHERE ID = 39;
512UPDATE Movies SET Description = 'A sexually frustrated suburban father has a mid-life crisis after becoming infatuated with his daughter\'s best friend.' WHERE ID = 71;
513UPDATE Movies SET Description = 'Will Hunting, a janitor at M.I.T., has a gift for mathematics, but needs help from a psychologist to find direction in his life.' WHERE ID = 29;
514UPDATE Movies SET Description = 'A cowboy doll is profoundly threatened and jealous when a new spaceman figure supplants him as top toy in a boy\'s room.' WHERE ID = 44;
515UPDATE Movies SET Description = 'When his secret bride is executed for assaulting an English soldier who tried to rape her, William Wallace begins a revolt against King Edward I of England.' WHERE ID = 58;
516UPDATE Movies SET Description = 'After a space merchant vessel receives an unknown transmission as a distress call, one of the crew is attacked by a mysterious life form and they soon realize that its life cycle has merely begun.' WHERE ID = 1;
517UPDATE Movies SET Description = 'The story of a young boy who witnesses Billy the Kid\'s encounter with Sheriff Pat Garrett.' WHERE ID = 3;
518UPDATE Movies SET Description = 'The Discovery One and its revolutionary super computer seek a mysterious monolith that first appeared at the dawn of mans' WHERE ID = 13;
519UPDATE Movies SET Description = 'An ad-man becomes involved in a bewildering cross-country chase involving enemy spies, the police and a beautiful woman.' WHERE ID = 17;
520UPDATE Movies SET Description = 'Detective Scottie who suffers from acrophobia is hired to investigate the strange activities of an old friend\'s wife. She commits suicide while Scottie becomes dangerously obsessed with her.' WHERE ID = 25;
521UPDATE Movies SET Description = 'Alex, a psychopathic delinquent, is imprisoned for murder and rape. In order to reduce his sentence, he volunteers for an experimental therapy conducted by the government, but it goes askew.' WHERE ID = 31;
522UPDATE Movies SET Description = 'During the Vietnam War, under the ruthless command of Hartman, a few recruits face mental breakdowns. After a bizarre event, the soldiers are left to deal with the war\'s hellish mayhem.' WHERE ID = 50;
523UPDATE Movies SET Description = 'When the police in a German city are unable to catch a child-murderer, other criminals join in the manhunt.' WHERE ID = 53;
524UPDATE Movies SET Description = 'Six criminals, hired to steal diamonds, do not know each other\'s true identity. While attempting the heist, the police ambushes them, leading them to believe that one of them is an undercover officer.' WHERE ID = 65;
525UPDATE Movies SET Description = 'After a daring mission to rescue Han Solo from Jabba the Hutt, the Rebels dispatch to Endor to destroy the second Death Star. Meanwhile, Luke struggles to help Darth Vader back from the dark side without falling into the Emperor\'s trap.' WHERE ID = 79;
526UPDATE Movies SET Description = 'Following the death of publishing tycoon Charles Foster Kane, reporters scramble to uncover the meaning of his final utterance; \'Rosebud\'.' WHERE ID = 87;
527UPDATE Movies SET Description = 'The claustrophobic world of a WWII German U-boat; boredom, filth and sheer terror.' WHERE ID = 88;
528UPDATE Movies SET Description = 'The life, success and troubles of Wolfgang Amadeus Mozart, as told by Antonio Salieri, the contemporaneous composer who was insanely jealous of Mozart\'s talent and claimed to have murdered him.' WHERE ID = 91;
529
530select * from Movies;
531
532#################################################################################### insert Directors
533
534INSERT INTO Directors (Name) VALUES ('Aamir Khan'); #1
535INSERT INTO Directors (Name) VALUES ('Adrian Molina (co-director)'); #2
536INSERT INTO Directors (Name) VALUES ('Alfred Hitchcock'); #3
537INSERT INTO Directors (Name) VALUES ('Amole Gupte'); #4
538INSERT INTO Directors (Name) VALUES ('Andrew Stanton'); #5
539INSERT INTO Directors (Name) VALUES ('Anthony Russo'); #6
540INSERT INTO Directors (Name) VALUES ('Billy Wilder'); #7
541INSERT INTO Directors (Name) VALUES ('Bob Persichetti'); #8
542INSERT INTO Directors (Name) VALUES ('Bong Joon Ho'); #9
543INSERT INTO Directors (Name) VALUES ('Bryan Singer'); #10
544INSERT INTO Directors (Name) VALUES ('Chan-wook Park'); #11
545INSERT INTO Directors (Name) VALUES ('Charles Chaplin'); #12
546INSERT INTO Directors (Name) VALUES ('Christopher Nolan'); #13
547INSERT INTO Directors (Name) VALUES ('Damien Chazelle'); #14
548INSERT INTO Directors (Name) VALUES ('Darren Aronofsky'); #15
549INSERT INTO Directors (Name) VALUES ('David Fincher'); #16
550INSERT INTO Directors (Name) VALUES ('Fernando Meirelles'); #17
551INSERT INTO Directors (Name) VALUES ('Florian Henckel von Donnersmarck'); #18
552INSERT INTO Directors (Name) VALUES ('Francis Ford Coppola'); #19
553INSERT INTO Directors (Name) VALUES ('Frank Capra'); #20
554INSERT INTO Directors (Name) VALUES ('Frank Darabont'); #21
555INSERT INTO Directors (Name) VALUES ('Fritz Lang'); #22
556INSERT INTO Directors (Name) VALUES ('George Lucas'); #23
557INSERT INTO Directors (Name) VALUES ('Giuseppe Tornatore'); #24
558INSERT INTO Directors (Name) VALUES ('Gus Van Sant'); #25
559INSERT INTO Directors (Name) VALUES ('Guy Ritchie'); #26
560INSERT INTO Directors (Name) VALUES ('Hayao Miyazaki'); #27
561INSERT INTO Directors (Name) VALUES ('Irvin Kershner'); #28
562INSERT INTO Directors (Name) VALUES ('Isao Takahata'); #29
563INSERT INTO Directors (Name) VALUES ('James Cameron'); #30
564INSERT INTO Directors (Name) VALUES ('Jean-Pierre Jeunet'); #31
565INSERT INTO Directors (Name) VALUES ('Joe Russo'); #32
566INSERT INTO Directors (Name) VALUES ('John Lasseter'); #33
567INSERT INTO Directors (Name) VALUES ('Jonathan Demme'); #34
568INSERT INTO Directors (Name) VALUES ('Kátia Lund'); #35
569INSERT INTO Directors (Name) VALUES ('Lana Wachowski'); #36
570INSERT INTO Directors (Name) VALUES ('Lee Unkrich'); #37
571INSERT INTO Directors (Name) VALUES ('Lilly Wachowski'); #38
572INSERT INTO Directors (Name) VALUES ('Luc Besson'); #39
573INSERT INTO Directors (Name) VALUES ('Makoto Shinkai'); #40
574INSERT INTO Directors (Name) VALUES ('Martin Scorsese'); #41
575INSERT INTO Directors (Name) VALUES ('Masaki Kobayashi'); #42
576INSERT INTO Directors (Name) VALUES ('Mel Gibson'); #43
577INSERT INTO Directors (Name) VALUES ('Michael Curtiz'); #44
578INSERT INTO Directors (Name) VALUES ('Michel Gondry'); #45
579INSERT INTO Directors (Name) VALUES ('Milos Forman'); #46
580INSERT INTO Directors (Name) VALUES ('Nitesh Tiwari'); #47
581INSERT INTO Directors (Name) VALUES ('Olivier Nakache'); #48
582INSERT INTO Directors (Name) VALUES ('Orson Welles'); #49
583INSERT INTO Directors (Name) VALUES ('Peter Jackson'); #50
584INSERT INTO Directors (Name) VALUES ('Peter Ramsey'); #51
585INSERT INTO Directors (Name) VALUES ('Quentin Tarantino'); #52
586INSERT INTO Directors (Name) VALUES ('Rajkumar Hirani'); #53
587INSERT INTO Directors (Name) VALUES ('Richard Marquand'); #54
588INSERT INTO Directors (Name) VALUES ('Ridley Scott'); #55
589INSERT INTO Directors (Name) VALUES ('Rob Minkoff'); #56
590INSERT INTO Directors (Name) VALUES ('Robert Zemeckis'); #57
591INSERT INTO Directors (Name) VALUES ('Roberto Benigni'); #58
592INSERT INTO Directors (Name) VALUES ('Roger Allers'); #59
593INSERT INTO Directors (Name) VALUES ('Roman Polanski'); #60
594INSERT INTO Directors (Name) VALUES ('Sam Mendes'); #61
595INSERT INTO Directors (Name) VALUES ('Sergio Leone'); #62
596INSERT INTO Directors (Name) VALUES ('Sidney Lumet'); #63
597INSERT INTO Directors (Name) VALUES ('Stanley Kubrick'); #64
598INSERT INTO Directors (Name) VALUES ('Steven Spielberg'); #65
599INSERT INTO Directors (Name) VALUES ('Thomas Vinterberg'); #66
600INSERT INTO Directors (Name) VALUES ('Todd Phillips'); #67
601INSERT INTO Directors (Name) VALUES ('Tony Kaye'); #68
602INSERT INTO Directors (Name) VALUES ('Wolfgang Petersen'); #69
603INSERT INTO Directors (Name) VALUES ('Éric Toledano'); #70
604
605select * from Directors order by ID asc;
606
607#################################################################################### insert Cast
608
609INSERT INTO Cast (Name) VALUES ('Aamir Khan'); #1
610INSERT INTO Cast (Name) VALUES ('Aaron Eckhart'); #2
611INSERT INTO Cast (Name) VALUES ('Adolphe Menjou'); #3
612INSERT INTO Cast (Name) VALUES ('Adrien Brody'); #4
613INSERT INTO Cast (Name) VALUES ('Akemi Yamaguchi'); #5
614INSERT INTO Cast (Name) VALUES ('Akira Ishihama'); #6
615INSERT INTO Cast (Name) VALUES ('Al Pacino'); #7
616INSERT INTO Cast (Name) VALUES ('Alexandre Rodrigues'); #8
617INSERT INTO Cast (Name) VALUES ('Anne Hathaway'); #9
618INSERT INTO Cast (Name) VALUES ('Anne Le Ny'); #10
619INSERT INTO Cast (Name) VALUES ('Annette Bening'); #11
620INSERT INTO Cast (Name) VALUES ('Annika Wedderkopp'); #12
621INSERT INTO Cast (Name) VALUES ('Anthony Gonzalez'); #13
622INSERT INTO Cast (Name) VALUES ('Anthony Hopkins'); #14
623INSERT INTO Cast (Name) VALUES ('Anthony Perkins'); #15
624INSERT INTO Cast (Name) VALUES ('Antonella Attili'); #16
625INSERT INTO Cast (Name) VALUES ('Arnold Schwarzenegger'); #17
626INSERT INTO Cast (Name) VALUES ('Audrey Tautou'); #18
627INSERT INTO Cast (Name) VALUES ('Ayano Shiraishi'); #19
628INSERT INTO Cast (Name) VALUES ('Barbara Bel Geddes'); #20
629INSERT INTO Cast (Name) VALUES ('Ben Affleck'); #21
630INSERT INTO Cast (Name) VALUES ('Ben Burtt'); #22
631INSERT INTO Cast (Name) VALUES ('Ben Kingsley'); #23
632INSERT INTO Cast (Name) VALUES ('Benicio Del Toro'); #24
633INSERT INTO Cast (Name) VALUES ('Benjamin Bratt'); #25
634INSERT INTO Cast (Name) VALUES ('Beverly D\'Angelo'); #26
635INSERT INTO Cast (Name) VALUES ('Bob Gunton'); #27
636INSERT INTO Cast (Name) VALUES ('Brad Pitt'); #28
637INSERT INTO Cast (Name) VALUES ('Carrie Fisher'); #29
638INSERT INTO Cast (Name) VALUES ('Carrie Henn'); #30
639INSERT INTO Cast (Name) VALUES ('Carrie-Anne Moss'); #31
640INSERT INTO Cast (Name) VALUES ('Cary Grant'); #32
641INSERT INTO Cast (Name) VALUES ('Charles Bronson'); #33
642INSERT INTO Cast (Name) VALUES ('Charles Chaplin'); #34
643INSERT INTO Cast (Name) VALUES ('Charles Laughton'); #35
644INSERT INTO Cast (Name) VALUES ('Chazz Palminteri'); #36
645INSERT INTO Cast (Name) VALUES ('Chris Evans'); #37
646INSERT INTO Cast (Name) VALUES ('Chris Hemsworth'); #38
647INSERT INTO Cast (Name) VALUES ('Christian Bale'); #39
648INSERT INTO Cast (Name) VALUES ('Christoph Waltz'); #40
649INSERT INTO Cast (Name) VALUES ('Christopher Lloyd'); #41
650INSERT INTO Cast (Name) VALUES ('Claudia Cardinale'); #42
651INSERT INTO Cast (Name) VALUES ('Clint Eastwood'); #43
652INSERT INTO Cast (Name) VALUES ('Connie Nielsen'); #44
653INSERT INTO Cast (Name) VALUES ('Danny Lloyd'); #45
654INSERT INTO Cast (Name) VALUES ('Darsheel Safary'); #46
655INSERT INTO Cast (Name) VALUES ('Daveigh Chase'); #47
656INSERT INTO Cast (Name) VALUES ('David Morse'); #48
657INSERT INTO Cast (Name) VALUES ('Diane Kruger'); #49
658INSERT INTO Cast (Name) VALUES ('Don Rickles'); #50
659INSERT INTO Cast (Name) VALUES ('Donna Reed'); #51
660INSERT INTO Cast (Name) VALUES ('Dorothy Comingore'); #52
661INSERT INTO Cast (Name) VALUES ('Edna Purviance'); #53
662INSERT INTO Cast (Name) VALUES ('Edward Furlong'); #54
663INSERT INTO Cast (Name) VALUES ('Edward Norton'); #55
664INSERT INTO Cast (Name) VALUES ('Eli Roth'); #56
665INSERT INTO Cast (Name) VALUES ('Eli Wallach'); #57
666INSERT INTO Cast (Name) VALUES ('Elijah Wood'); #58
667INSERT INTO Cast (Name) VALUES ('Elissa Knight'); #59
668INSERT INTO Cast (Name) VALUES ('Elizabeth Berridge'); #60
669INSERT INTO Cast (Name) VALUES ('Elizabeth McGovern'); #61
670INSERT INTO Cast (Name) VALUES ('Ellen Burstyn'); #62
671INSERT INTO Cast (Name) VALUES ('Ellen Page'); #63
672INSERT INTO Cast (Name) VALUES ('Ellen Widmann'); #64
673INSERT INTO Cast (Name) VALUES ('Enzo Cannavale'); #65
674INSERT INTO Cast (Name) VALUES ('Erich von Stroheim'); #66
675INSERT INTO Cast (Name) VALUES ('Eva Marie Saint'); #67
676INSERT INTO Cast (Name) VALUES ('F. Murray Abraham'); #68
677INSERT INTO Cast (Name) VALUES ('Fatima Sana Shaikh'); #69
678INSERT INTO Cast (Name) VALUES ('Florence Lee'); #70
679INSERT INTO Cast (Name) VALUES ('Frank Finlay'); #71
680INSERT INTO Cast (Name) VALUES ('François Cluzet'); #72
681INSERT INTO Cast (Name) VALUES ('Gabriel Byrne'); #73
682INSERT INTO Cast (Name) VALUES ('Gael García Bernal'); #74
683INSERT INTO Cast (Name) VALUES ('Gary Lockwood'); #75
684INSERT INTO Cast (Name) VALUES ('Gary Oldman'); #76
685INSERT INTO Cast (Name) VALUES ('Gary Sinise'); #77
686INSERT INTO Cast (Name) VALUES ('George C. Scott'); #78
687INSERT INTO Cast (Name) VALUES ('Giorgio Cantarini'); #79
688INSERT INTO Cast (Name) VALUES ('Gloria Swanson'); #80
689INSERT INTO Cast (Name) VALUES ('Grace Kelly'); #81
690INSERT INTO Cast (Name) VALUES ('Guy Pearce'); #82
691INSERT INTO Cast (Name) VALUES ('Hailee Steinfeld'); #83
692INSERT INTO Cast (Name) VALUES ('Harrison Ford'); #84
693INSERT INTO Cast (Name) VALUES ('Harvey Keitel'); #85
694INSERT INTO Cast (Name) VALUES ('Heath Ledger'); #86
695INSERT INTO Cast (Name) VALUES ('Henry Bergman'); #87
696INSERT INTO Cast (Name) VALUES ('Henry Fonda'); #88
697INSERT INTO Cast (Name) VALUES ('Herbert Grönemeyer'); #89
698INSERT INTO Cast (Name) VALUES ('Hugh Jackman'); #90
699INSERT INTO Cast (Name) VALUES ('Humphrey Bogart'); #91
700INSERT INTO Cast (Name) VALUES ('Hye-jeong Kang'); #92
701INSERT INTO Cast (Name) VALUES ('Ian McKellen'); #93
702INSERT INTO Cast (Name) VALUES ('Inge Landgut'); #94
703INSERT INTO Cast (Name) VALUES ('Ingrid Bergman'); #95
704INSERT INTO Cast (Name) VALUES ('J.K. Simmons'); #96
705INSERT INTO Cast (Name) VALUES ('Jack Nicholson'); #97
706INSERT INTO Cast (Name) VALUES ('Jack Oakie'); #98
707INSERT INTO Cast (Name) VALUES ('Jackie Coogan'); #99
708INSERT INTO Cast (Name) VALUES ('Jake Johnson'); #100
709INSERT INTO Cast (Name) VALUES ('James Caan'); #101
710INSERT INTO Cast (Name) VALUES ('James Earl Jones'); #102
711INSERT INTO Cast (Name) VALUES ('James Mason'); #103
712INSERT INTO Cast (Name) VALUES ('James Stewart'); #104
713INSERT INTO Cast (Name) VALUES ('James Woods'); #105
714INSERT INTO Cast (Name) VALUES ('Jamie Foxx'); #106
715INSERT INTO Cast (Name) VALUES ('Janet Leigh'); #107
716INSERT INTO Cast (Name) VALUES ('Jared Leto'); #108
717INSERT INTO Cast (Name) VALUES ('Jason Statham'); #109
718INSERT INTO Cast (Name) VALUES ('Jean Reno'); #110
719INSERT INTO Cast (Name) VALUES ('Jeff Garlin'); #111
720INSERT INTO Cast (Name) VALUES ('Jennifer Connelly'); #112
721INSERT INTO Cast (Name) VALUES ('Jeremy Irons'); #113
722INSERT INTO Cast (Name) VALUES ('Jessica Chastain'); #114
723INSERT INTO Cast (Name) VALUES ('Ji-Tae Yoo'); #115
724INSERT INTO Cast (Name) VALUES ('Jim Carrey'); #116
725INSERT INTO Cast (Name) VALUES ('Joaquin Phoenix'); #117
726INSERT INTO Cast (Name) VALUES ('Jodie Foster'); #118
727INSERT INTO Cast (Name) VALUES ('Joe Pantoliano'); #119
728INSERT INTO Cast (Name) VALUES ('Joe Pesci'); #120
729INSERT INTO Cast (Name) VALUES ('John Hurt'); #121
730INSERT INTO Cast (Name) VALUES ('John Travolta'); #122
731INSERT INTO Cast (Name) VALUES ('Joseph Cotten'); #123
732INSERT INTO Cast (Name) VALUES ('Joseph Gordon-Levitt'); #124
733INSERT INTO Cast (Name) VALUES ('Jürgen Prochnow'); #125
734INSERT INTO Cast (Name) VALUES ('Kang-ho Song'); #126
735INSERT INTO Cast (Name) VALUES ('Karen Allen'); #127
736INSERT INTO Cast (Name) VALUES ('Kate Winslet'); #128
737INSERT INTO Cast (Name) VALUES ('Keanu Reeves'); #129
738INSERT INTO Cast (Name) VALUES ('Keiko Tsushima'); #130
739INSERT INTO Cast (Name) VALUES ('Keir Dullea'); #131
740INSERT INTO Cast (Name) VALUES ('Kevin Spacey'); #132
741INSERT INTO Cast (Name) VALUES ('Kim Novak'); #133
742INSERT INTO Cast (Name) VALUES ('Kirk Douglas'); #134
743INSERT INTO Cast (Name) VALUES ('Klaus Wennemann'); #135
744INSERT INTO Cast (Name) VALUES ('Laurence Fishburne'); #136
745INSERT INTO Cast (Name) VALUES ('Lawrence A. Bonney'); #137
746INSERT INTO Cast (Name) VALUES ('Lea Thompson'); #138
747INSERT INTO Cast (Name) VALUES ('Leandro Firmino'); #139
748INSERT INTO Cast (Name) VALUES ('Lee J. Cobb'); #140
749INSERT INTO Cast (Name) VALUES ('Lee Van Cleef'); #141
750INSERT INTO Cast (Name) VALUES ('Leonardo DiCaprio'); #142
751INSERT INTO Cast (Name) VALUES ('Liam Neeson'); #143
752INSERT INTO Cast (Name) VALUES ('Linda Hamilton'); #144
753INSERT INTO Cast (Name) VALUES ('Lionel Barrymore'); #145
754INSERT INTO Cast (Name) VALUES ('Louise Fletcher'); #146
755INSERT INTO Cast (Name) VALUES ('Madhavan'); #147
756INSERT INTO Cast (Name) VALUES ('Mads Mikkelsen'); #148
757INSERT INTO Cast (Name) VALUES ('Malcolm McDowell'); #149
758INSERT INTO Cast (Name) VALUES ('Mark Hamill'); #150
759INSERT INTO Cast (Name) VALUES ('Mark Ruffalo'); #151
760INSERT INTO Cast (Name) VALUES ('Marlene Dietrich'); #152
761INSERT INTO Cast (Name) VALUES ('Marlon Brando'); #153
762INSERT INTO Cast (Name) VALUES ('Martin Balsam'); #154
763INSERT INTO Cast (Name) VALUES ('Martin Sheen'); #155
764INSERT INTO Cast (Name) VALUES ('Martina Gedeck'); #156
765INSERT INTO Cast (Name) VALUES ('Matheus Nachtergaele'); #157
766INSERT INTO Cast (Name) VALUES ('Mathieu Kassovitz'); #158
767INSERT INTO Cast (Name) VALUES ('Matt Damon'); #159
768INSERT INTO Cast (Name) VALUES ('Matthew Broderick'); #160
769INSERT INTO Cast (Name) VALUES ('Matthew McConaughey'); #161
770INSERT INTO Cast (Name) VALUES ('Matthew Modine'); #162
771INSERT INTO Cast (Name) VALUES ('Meat Loaf'); #163
772INSERT INTO Cast (Name) VALUES ('Mel Gibson'); #164
773INSERT INTO Cast (Name) VALUES ('Melissa Benoist'); #165
774INSERT INTO Cast (Name) VALUES ('Michael Bates'); #166
775INSERT INTO Cast (Name) VALUES ('Michael Biehn'); #167
776INSERT INTO Cast (Name) VALUES ('Michael Clarke Duncan'); #168
777INSERT INTO Cast (Name) VALUES ('Michael J. Fox'); #169
778INSERT INTO Cast (Name) VALUES ('Michael Madsen'); #170
779INSERT INTO Cast (Name) VALUES ('Miles Teller'); #171
780INSERT INTO Cast (Name) VALUES ('Min-sik Choi'); #172
781INSERT INTO Cast (Name) VALUES ('Miyu Irino'); #173
782INSERT INTO Cast (Name) VALUES ('Mona Singh'); #174
783INSERT INTO Cast (Name) VALUES ('Mone Kamishiraishi'); #175
784INSERT INTO Cast (Name) VALUES ('Morgan Freeman'); #176
785INSERT INTO Cast (Name) VALUES ('Natalie Portman'); #177
786INSERT INTO Cast (Name) VALUES ('Nicoletta Braschi'); #178
787INSERT INTO Cast (Name) VALUES ('Omar Sy'); #179
788INSERT INTO Cast (Name) VALUES ('Orlando Bloom'); #180
789INSERT INTO Cast (Name) VALUES ('Orson Welles'); #181
790INSERT INTO Cast (Name) VALUES ('Patrick Magee'); #182
791INSERT INTO Cast (Name) VALUES ('Patrick McGoohan'); #183
792INSERT INTO Cast (Name) VALUES ('Paul Freeman'); #184
793INSERT INTO Cast (Name) VALUES ('Paul Henreid'); #185
794INSERT INTO Cast (Name) VALUES ('Paulette Goddard'); #186
795INSERT INTO Cast (Name) VALUES ('Peter Lorre'); #187
796INSERT INTO Cast (Name) VALUES ('Peter Sellers'); #188
797INSERT INTO Cast (Name) VALUES ('Philippe Noiret'); #189
798INSERT INTO Cast (Name) VALUES ('R. Lee Ermey'); #190
799INSERT INTO Cast (Name) VALUES ('Ralph Fiennes'); #191
800INSERT INTO Cast (Name) VALUES ('Ralph Meeker'); #192
801INSERT INTO Cast (Name) VALUES ('Ray Liotta'); #193
802INSERT INTO Cast (Name) VALUES ('Robert De Niro'); #194
803INSERT INTO Cast (Name) VALUES ('Robert Downey Jr.'); #195
804INSERT INTO Cast (Name) VALUES ('Robert Duvall'); #196
805INSERT INTO Cast (Name) VALUES ('Roberto Benigni'); #197
806INSERT INTO Cast (Name) VALUES ('Robin Williams'); #198
807INSERT INTO Cast (Name) VALUES ('Robin Wright'); #199
808INSERT INTO Cast (Name) VALUES ('Rufus'); #200
809INSERT INTO Cast (Name) VALUES ('Russell Crowe'); #201
810INSERT INTO Cast (Name) VALUES ('Ryô Narita'); #202
811INSERT INTO Cast (Name) VALUES ('Ryûnosuke Kamiki'); #203
812INSERT INTO Cast (Name) VALUES ('Sakshi Tanwar'); #204
813INSERT INTO Cast (Name) VALUES ('Samuel L. Jackson'); #205
814INSERT INTO Cast (Name) VALUES ('Scarlett Johansson'); #206
815INSERT INTO Cast (Name) VALUES ('Sebastian Koch'); #207
816INSERT INTO Cast (Name) VALUES ('Shameik Moore'); #208
817INSERT INTO Cast (Name) VALUES ('Shelley Duvall'); #209
818INSERT INTO Cast (Name) VALUES ('Shima Iwashita'); #210
819INSERT INTO Cast (Name) VALUES ('Sigourney Weaver'); #211
820INSERT INTO Cast (Name) VALUES ('Sophie Marceau'); #212
821INSERT INTO Cast (Name) VALUES ('Sterling Hayden'); #213
822INSERT INTO Cast (Name) VALUES ('Sun-kyun Lee'); #214
823INSERT INTO Cast (Name) VALUES ('Suzanne Pleshette'); #215
824INSERT INTO Cast (Name) VALUES ('Takashi Shimura'); #216
825INSERT INTO Cast (Name) VALUES ('Tatsuya Nakadai'); #217
826INSERT INTO Cast (Name) VALUES ('Thomas Bo Larsen'); #218
827INSERT INTO Cast (Name) VALUES ('Thomas Kretschmann'); #219
828INSERT INTO Cast (Name) VALUES ('Thora Birch'); #220
829INSERT INTO Cast (Name) VALUES ('Tim Allen'); #221
830INSERT INTO Cast (Name) VALUES ('Tim Robbins'); #222
831INSERT INTO Cast (Name) VALUES ('Tim Roth'); #223
832INSERT INTO Cast (Name) VALUES ('Tisca Chopra'); #224
833INSERT INTO Cast (Name) VALUES ('Tom Hanks'); #225
834INSERT INTO Cast (Name) VALUES ('Tom Hardy'); #226
835INSERT INTO Cast (Name) VALUES ('Tom Hulce'); #227
836INSERT INTO Cast (Name) VALUES ('Tom Sizemore'); #228
837INSERT INTO Cast (Name) VALUES ('Tom Skerritt'); #229
838INSERT INTO Cast (Name) VALUES ('Tom Wilkinson'); #230
839INSERT INTO Cast (Name) VALUES ('Toshirô Mifune'); #231
840INSERT INTO Cast (Name) VALUES ('Tsutomu Tatsumi'); #232
841INSERT INTO Cast (Name) VALUES ('Tyrone Power'); #233
842INSERT INTO Cast (Name) VALUES ('Ulrich Mühe'); #234
843INSERT INTO Cast (Name) VALUES ('Uma Thurman'); #235
844INSERT INTO Cast (Name) VALUES ('Vera Miles'); #236
845INSERT INTO Cast (Name) VALUES ('Viggo Mortensen'); #237
846INSERT INTO Cast (Name) VALUES ('Vincent D\'Onofrio'); #238
847INSERT INTO Cast (Name) VALUES ('Virginia Cherrill'); #239
848INSERT INTO Cast (Name) VALUES ('Wendell Corey'); #240
849INSERT INTO Cast (Name) VALUES ('Will Sampson'); #241
850INSERT INTO Cast (Name) VALUES ('William Holden'); #242
851INSERT INTO Cast (Name) VALUES ('William Sylvester'); #243
852INSERT INTO Cast (Name) VALUES ('Yeo-jeong Jo'); #244
853INSERT INTO Cast (Name) VALUES ('Yuriko Ishida'); #245
854INSERT INTO Cast (Name) VALUES ('Yôji Matsuda'); #246
855INSERT INTO Cast (Name) VALUES ('Yûko Tanaka'); #247
856INSERT INTO Cast (Name) VALUES ('Zazie Beetz'); #248
857
858select * from Cast order by ID asc;
859
860#################################################################################### insert Genre
861
862INSERT INTO Genres (Genre) VALUES ('Action'); #1
863INSERT INTO Genres (Genre) VALUES ('Adventure'); #2
864INSERT INTO Genres (Genre) VALUES ('Animation'); #3
865INSERT INTO Genres (Genre) VALUES ('Biography'); #4
866INSERT INTO Genres (Genre) VALUES ('Comedy'); #5
867INSERT INTO Genres (Genre) VALUES ('Crime'); #6
868INSERT INTO Genres (Genre) VALUES ('Drama'); #7
869INSERT INTO Genres (Genre) VALUES ('Family'); #8
870INSERT INTO Genres (Genre) VALUES ('Fantasy'); #9
871INSERT INTO Genres (Genre) VALUES ('Film-Noir'); #10
872INSERT INTO Genres (Genre) VALUES ('History'); #11
873INSERT INTO Genres (Genre) VALUES ('Horror'); #12
874INSERT INTO Genres (Genre) VALUES ('Music'); #13
875INSERT INTO Genres (Genre) VALUES ('Musical'); #14
876INSERT INTO Genres (Genre) VALUES ('Mystery'); #15
877INSERT INTO Genres (Genre) VALUES ('Romance'); #16
878INSERT INTO Genres (Genre) VALUES ('Sci-Fi'); #17
879INSERT INTO Genres (Genre) VALUES ('Sport'); #18
880INSERT INTO Genres (Genre) VALUES ('Thriller'); #19
881INSERT INTO Genres (Genre) VALUES ('War'); #20
882INSERT INTO Genres (Genre) VALUES ('Western'); #21
883
884select * from Genres order by ID asc;
885
886#################################################################################### insert MovieDirectors
887
888INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (1,30); # James Cameron is the director of Aliens
889INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (2,46); # Milos Forman is the director of One Flew Over the Cuckoo\'s Nest
890INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (3,12); # Charles Chaplin is the director of The Kid
891INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (4,58); # Roberto Benigni is the director of Life Is Beautiful
892INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (5,27); # Hayao Miyazaki is the director of Princess Mononoke
893INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (6,7); # Billy Wilder is the director of Witness for the Prosecution
894INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (7,10); # Bryan Singer is the director of The Usual Suspects
895INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (8,60); # Roman Polanski is the director of The Pianist
896INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (9,6); # Anthony Russo is the director of Avengers: Infinity War
897INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (9,32); # Joe Russo is the director of Avengers: Infinity War
898INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (10,50); # Peter Jackson is the director of The Lord of the Rings: The Return of the King
899INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (11,31); # Jean-Pierre Jeunet is the director of Amélie
900INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (12,36); # Lana Wachowski is the director of The Matrix
901INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (12,38); # Lilly Wachowski is the director of The Matrix
902INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (13,64); # Stanley Kubrick is the director of 2001: A Space Odyssey
903INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (14,50); # Peter Jackson is the director of The Lord of the Rings: The Two Towers
904INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (15,28); # Irvin Kershner is the director of Star Wars: Episode V - The Empire Strikes Back
905INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (16,19); # Francis Ford Coppola is the director of Apocalypse Now
906INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (17,3); # Alfred Hitchcock is the director of North by Northwest
907INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (18,64); # Stanley Kubrick is the director of The Shining
908INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (19,1); # Aamir Khan is the director of 3 Idiots
909INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (19,53); # Rajkumar Hirani is the director of 3 Idiots
910INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (20,6); # Anthony Russo is the director of Avengers: Endgame
911INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (20,32); # Joe Russo is the director of Avengers: Endgame
912INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (21,62); # Sergio Leone is the director of Once Upon a Time in America
913INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (22,13); # Christopher Nolan is the director of The Dark Knight
914INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (23,48); # Olivier Nakache is the director of Untouchable
915INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (23,70); # Éric Toledano is the director of Untouchable
916INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (24,44); # Michael Curtiz is the director of Casablanca
917INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (25,3); # Alfred Hitchcock is the director of Vertigo
918INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (26,13); # Christopher Nolan is the director of Interstellar
919INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (27,42); # Masaki Kobayashi is the director of Harakiri
920INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (28,23); # George Lucas is the director of Star Wars: Episode IV - A New Hope
921INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (29,25); # Gus Van Sant is the director of Good Will Hunting
922INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (30,1); # Aamir Khan is the director of Dangal
923INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (30,47); # Nitesh Tiwari is the director of Dangal
924INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (31,64); # Stanley Kubrick is the director of A Clockwork Orange
925INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (32,45); # Michel Gondry is the director of Eternal Sunshine of the Spotless Mind
926INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (33,2); # Adrian Molina (co-director) is the director of Coco
927INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (33,37); # Lee Unkrich is the director of Coco
928INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (33,70); # director is the director of Coco
929INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (34,1); # Aamir Khan is the director of Like Stars on Earth
930INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (34,4); # Amole Gupte is the director of Like Stars on Earth
931INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (35,63); # Sidney Lumet is the director of 12 Angry Men
932INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (36,41); # Martin Scorsese is the director of The Departed
933INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (37,13); # Christopher Nolan is the director of Inception
934INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (38,66); # Thomas Vinterberg is the director of The Hunt
935INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (39,15); # Darren Aronofsky is the director of Requiem for a Dream
936INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (40,5); # Andrew Stanton is the director of WALL·E
937INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (41,20); # Frank Capra is the director of It\'s a Wonderful Life
938INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (42,55); # Ridley Scott is the director of Alien
939INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (43,68); # Tony Kaye is the director of American History X
940INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (44,33); # John Lasseter is the director of Toy Story
941INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (46,12); # Charles Chaplin is the director of Modern Times
942INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (47,21); # Frank Darabont is the director of The Green Mile
943INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (48,65); # Steven Spielberg is the director of Schindler\'s List
944INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (49,3); # Alfred Hitchcock is the director of Rear Window
945INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (50,64); # Stanley Kubrick is the director of Full Metal Jacket
946INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (51,12); # Charles Chaplin is the director of City Lights
947INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (52,12); # Charles Chaplin is the director of The Great Dictator
948INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (53,22); # Fritz Lang is the director of M
949INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (54,29); # Isao Takahata is the director of Grave of the Fireflies
950INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (55,34); # Jonathan Demme is the director of The Silence of the Lambs
951INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (56,55); # Ridley Scott is the director of Gladiator
952INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (57,57); # Robert Zemeckis is the director of Back to the Future
953INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (58,43); # Mel Gibson is the director of Braveheart
954INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (59,39); # Luc Besson is the director of Leon
955INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (60,52); # Quentin Tarantino is the director of Inglourious Basterds
956INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (61,21); # Frank Darabont is the director of The Shawshank Redemption
957INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (62,11); # Chan-wook Park is the director of Oldboy
958INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (63,17); # Fernando Meirelles is the director of City of God
959INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (63,35); # Kátia Lund (co-director) is the director of City of God
960INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (64,57); # Robert Zemeckis is the director of Forrest Gump
961INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (65,52); # Quentin Tarantino is the director of Reservoir Dogs
962INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (66,50); # Peter Jackson is the director of The Lord of the Rings: The Fellowship of the Ring
963INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (67,67); # Todd Phillips is the director of Joker
964INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (68,13); # Christopher Nolan is the director of Memento
965INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (69,13); # Christopher Nolan is the director of The Prestige
966INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (70,40); # Makoto Shinkai is the director of Your Name.
967INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (71,61); # Sam Mendes is the director of American Beauty
968INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (72,18); # Florian Henckel von Donnersmarck is the director of The Lives of Others
969INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (73,65); # Steven Spielberg is the director of Saving Private Ryan
970INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (74,23); # George Lucas is the director of Raiders of the Lost Ark
971INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (74,65); # Steven Spielberg is the director of Raiders of the Lost Ark
972INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (75,62); # Sergio Leone is the director of Once Upon a Time in the West
973INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (76,19); # Francis Ford Coppola is the director of The Godfather
974INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (77,30); # James Cameron is the director of Terminator 2: Judgment Day
975INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (78,56); # Rob Minkoff is the director of The Lion King
976INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (78,59); # Roger Allers is the director of The Lion King
977INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (79,23); # George Lucas is the director of Star Wars: Episode VI - Return of the Jedi
978INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (79,54); # Richard Marquand is the director of Star Wars: Episode VI - Return of the Jedi
979INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (80,16); # David Fincher is the director of Seven
980INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (81,7); # Billy Wilder is the director of Sunset Blvd.
981INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (82,27); # Hayao Miyazaki is the director of Spirited Away
982INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (83,52); # Quentin Tarantino is the director of Pulp Fiction
983INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (84,26); # Guy Ritchie is the director of Snatch
984INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (85,16); # David Fincher is the director of Fight Club
985INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (86,3); # Alfred Hitchcock is the director of Psycho
986INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (87,49); # Orson Welles is the director of Citizen Kane
987INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (88,69); # Wolfgang Petersen is the director of Das Boot
988INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (89,64); # Stanley Kubrick is the director of Paths of Glory
989INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (90,8); # Bob Persichetti is the director of Spider-Man: Into the Spider-Verse
990INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (90,51); # Peter Ramsey is the director of Spider-Man: Into the Spider-Verse
991INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (91,46); # Milos Forman is the director of Amadeus
992INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (92,52); # Quentin Tarantino is the director of Django Unchained
993INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (93,62); # Sergio Leone is the director of The Good, the Bad and the Ugly
994INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (94,41); # Martin Scorsese is the director of Goodfellas
995INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (95,14); # Damien Chazelle is the director of Whiplash
996INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (96,19); # Francis Ford Coppola is the director of The Godfather: Part II
997INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (97,9); # Bong Joon Ho is the director of Parasite
998INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (98,64); # Stanley Kubrick is the director of Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb
999INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (99,24); # Giuseppe Tornatore is the director of Cinema Paradiso
1000INSERT INTO MovieDirectors (MovieID,DirectorID) VALUES (100,13); # Christopher Nolan is the director of The Dark Knight Rises
1001
1002SELECT * FROM MovieDirectors ORDER BY MovieID ASC;
1003
1004#################################################################################### INSERT Writers
1005
1006INSERT INTO Writers (Name) VALUES ('Abhijat Joshi'); #1
1007INSERT INTO Writers (Name) VALUES ('Agatha Christie'); #2
1008INSERT INTO Writers (Name) VALUES ('Akiyuki Nosaka'); #3
1009INSERT INTO Writers (Name) VALUES ('Alan Ball'); #4
1010INSERT INTO Writers (Name) VALUES ('Alan Mak'); #5
1011INSERT INTO Writers (Name) VALUES ('Albert Hackett'); #6
1012INSERT INTO Writers (Name) VALUES ('Alec Coppel'); #7
1013INSERT INTO Writers (Name) VALUES ('Amole Gupte'); #8
1014INSERT INTO Writers (Name) VALUES ('Andrew Kevin Walker'); #9
1015INSERT INTO Writers (Name) VALUES ('Andrew Stanton'); #10
1016INSERT INTO Writers (Name) VALUES ('Anthony Burgess'); #11
1017INSERT INTO Writers (Name) VALUES ('Arthur C. Clarke'); #12
1018INSERT INTO Writers (Name) VALUES ('Ben Affleck'); #13
1019INSERT INTO Writers (Name) VALUES ('Billy Wilder'); #14
1020INSERT INTO Writers (Name) VALUES ('Bo Goldman'); #15
1021INSERT INTO Writers (Name) VALUES ('Bob Gale'); #16
1022INSERT INTO Writers (Name) VALUES ('Bong Joon Ho'); #17
1023INSERT INTO Writers (Name) VALUES ('Bráulio Mantovani'); #18
1024INSERT INTO Writers (Name) VALUES ('Calder Willingham'); #19
1025INSERT INTO Writers (Name) VALUES ('Charles Brackett'); #20
1026INSERT INTO Writers (Name) VALUES ('Charles Chaplin'); #21
1027INSERT INTO Writers (Name) VALUES ('Charlie Kaufman'); #22
1028INSERT INTO Writers (Name) VALUES ('Christopher Markus'); #23
1029INSERT INTO Writers (Name) VALUES ('Christopher McQuarrie'); #24
1030INSERT INTO Writers (Name) VALUES ('Christopher Nolan'); #25
1031INSERT INTO Writers (Name) VALUES ('Chuck Palahniuk'); #26
1032INSERT INTO Writers (Name) VALUES ('Cornell Woolrich'); #27
1033INSERT INTO Writers (Name) VALUES ('Damien Chazelle'); #28
1034INSERT INTO Writers (Name) VALUES ('Dan O\'Bannon'); #29
1035INSERT INTO Writers (Name) VALUES ('David Franzoni'); #30
1036INSERT INTO Writers (Name) VALUES ('David Giler'); #31
1037INSERT INTO Writers (Name) VALUES ('David McKenna'); #32
1038INSERT INTO Writers (Name) VALUES ('Eric Roth'); #33
1039INSERT INTO Writers (Name) VALUES ('Ernest Lehman'); #34
1040INSERT INTO Writers (Name) VALUES ('Florian Henckel von Donnersmarck'); #35
1041INSERT INTO Writers (Name) VALUES ('Fran Walsh'); #36
1042INSERT INTO Writers (Name) VALUES ('Frances Goodrich'); #37
1043INSERT INTO Writers (Name) VALUES ('Francis Ford Coppola'); #38
1044INSERT INTO Writers (Name) VALUES ('Frank Darabont'); #39
1045INSERT INTO Writers (Name) VALUES ('Fritz Lang'); #40
1046INSERT INTO Writers (Name) VALUES ('Garon Tsuchiya'); #41
1047INSERT INTO Writers (Name) VALUES ('George Lucas'); #42
1048INSERT INTO Writers (Name) VALUES ('Giuseppe Tornatore'); #43
1049INSERT INTO Writers (Name) VALUES ('Guillaume Laurant'); #44
1050INSERT INTO Writers (Name) VALUES ('Guy Ritchie'); #45
1051INSERT INTO Writers (Name) VALUES ('Harry Grey'); #46
1052INSERT INTO Writers (Name) VALUES ('Hayao Miyazaki'); #47
1053INSERT INTO Writers (Name) VALUES ('Herman J. Mankiewicz'); #48
1054INSERT INTO Writers (Name) VALUES ('Hubert Selby Jr.'); #49
1055INSERT INTO Writers (Name) VALUES ('Irene Mecchi'); #50
1056INSERT INTO Writers (Name) VALUES ('Isao Takahata'); #51
1057INSERT INTO Writers (Name) VALUES ('J.R.R. Tolkien'); #52
1058INSERT INTO Writers (Name) VALUES ('James Cameron'); #53
1059INSERT INTO Writers (Name) VALUES ('Jason Katz'); #54
1060INSERT INTO Writers (Name) VALUES ('Jean-Pierre Jeunet'); #55
1061INSERT INTO Writers (Name) VALUES ('Jim Uhls'); #56
1062INSERT INTO Writers (Name) VALUES ('John Lasseter'); #57
1063INSERT INTO Writers (Name) VALUES ('John Michael Hayes'); #58
1064INSERT INTO Writers (Name) VALUES ('John Milius'); #59
1065INSERT INTO Writers (Name) VALUES ('Jonathan Nolan'); #60
1066INSERT INTO Writers (Name) VALUES ('Jonathan Roberts'); #61
1067INSERT INTO Writers (Name) VALUES ('Joseph Stefano'); #62
1068INSERT INTO Writers (Name) VALUES ('Julius J. Epstein'); #63
1069INSERT INTO Writers (Name) VALUES ('Lana Wachowski'); #64
1070INSERT INTO Writers (Name) VALUES ('Lawrence Hauben'); #65
1071INSERT INTO Writers (Name) VALUES ('Lawrence Kasdan'); #66
1072INSERT INTO Writers (Name) VALUES ('Lee Unkrich'); #67
1073INSERT INTO Writers (Name) VALUES ('Leigh Brackett'); #68
1074INSERT INTO Writers (Name) VALUES ('Leonardo Benvenuti'); #69
1075INSERT INTO Writers (Name) VALUES ('Lilly Wachowski'); #70
1076INSERT INTO Writers (Name) VALUES ('Lothar G. Buchheim'); #71
1077INSERT INTO Writers (Name) VALUES ('Luc Besson'); #72
1078INSERT INTO Writers (Name) VALUES ('Luciano Vincenzoni'); #73
1079INSERT INTO Writers (Name) VALUES ('Makoto Shinkai'); #74
1080INSERT INTO Writers (Name) VALUES ('Mario Puzo'); #75
1081INSERT INTO Writers (Name) VALUES ('Matt Damon'); #76
1082INSERT INTO Writers (Name) VALUES ('Michael Herr'); #77
1083INSERT INTO Writers (Name) VALUES ('Michel Gondry'); #78
1084INSERT INTO Writers (Name) VALUES ('Neil Gaiman'); #79
1085INSERT INTO Writers (Name) VALUES ('Nicholas Pileggi'); #80
1086INSERT INTO Writers (Name) VALUES ('Nobuaki Minegishi'); #81
1087INSERT INTO Writers (Name) VALUES ('Olivier Nakache'); #82
1088INSERT INTO Writers (Name) VALUES ('Orson Welles'); #83
1089INSERT INTO Writers (Name) VALUES ('Paulo Lins'); #84
1090INSERT INTO Writers (Name) VALUES ('Pete Docter'); #85
1091INSERT INTO Writers (Name) VALUES ('Peter Shaffer'); #86
1092INSERT INTO Writers (Name) VALUES ('Phil Lord'); #87
1093INSERT INTO Writers (Name) VALUES ('Philip G. Epstein'); #88
1094INSERT INTO Writers (Name) VALUES ('Philippe Pozzo di Borgo'); #89
1095INSERT INTO Writers (Name) VALUES ('Piyush Gupta'); #90
1096INSERT INTO Writers (Name) VALUES ('Quentin Tarantino'); #91
1097INSERT INTO Writers (Name) VALUES ('Rajkumar Hirani'); #92
1098INSERT INTO Writers (Name) VALUES ('Randall Wallace'); #93
1099INSERT INTO Writers (Name) VALUES ('Reginald Rose'); #94
1100INSERT INTO Writers (Name) VALUES ('Robert Bloch'); #95
1101INSERT INTO Writers (Name) VALUES ('Robert Rodat'); #96
1102INSERT INTO Writers (Name) VALUES ('Robert Zemeckis'); #97
1103INSERT INTO Writers (Name) VALUES ('Roberto Benigni'); #98
1104INSERT INTO Writers (Name) VALUES ('Rodney Rothman'); #99
1105INSERT INTO Writers (Name) VALUES ('Roger Avary'); #100
1106INSERT INTO Writers (Name) VALUES ('Ronald Harwood'); #101
1107INSERT INTO Writers (Name) VALUES ('Samuel A. Taylor'); #102
1108INSERT INTO Writers (Name) VALUES ('Scott Silver'); #103
1109INSERT INTO Writers (Name) VALUES ('Sergio Donati'); #104
1110INSERT INTO Writers (Name) VALUES ('Sergio Leone'); #105
1111INSERT INTO Writers (Name) VALUES ('Shinobu Hashimoto'); #106
1112INSERT INTO Writers (Name) VALUES ('Shreyas Jain'); #107
1113INSERT INTO Writers (Name) VALUES ('Stanley Kubrick'); #108
1114INSERT INTO Writers (Name) VALUES ('Stephen King'); #109
1115INSERT INTO Writers (Name) VALUES ('Stephen McFeely'); #110
1116INSERT INTO Writers (Name) VALUES ('Steven Zaillian'); #111
1117INSERT INTO Writers (Name) VALUES ('Ted Tally'); #112
1118INSERT INTO Writers (Name) VALUES ('Terry Southern'); #113
1119INSERT INTO Writers (Name) VALUES ('Thea von Harbou'); #114
1120INSERT INTO Writers (Name) VALUES ('Thomas Harris'); #115
1121INSERT INTO Writers (Name) VALUES ('Thomas Keneally'); #116
1122INSERT INTO Writers (Name) VALUES ('Thomas Vinterberg'); #117
1123INSERT INTO Writers (Name) VALUES ('Tobias Lindholm'); #118
1124INSERT INTO Writers (Name) VALUES ('Todd Phillips'); #119
1125INSERT INTO Writers (Name) VALUES ('Vincenzo Cerami'); #120
1126INSERT INTO Writers (Name) VALUES ('William Monahan'); #121
1127INSERT INTO Writers (Name) VALUES ('William Wisher'); #122
1128INSERT INTO Writers (Name) VALUES ('Winston Groom'); #123
1129INSERT INTO Writers (Name) VALUES ('Wladyslaw Szpilman'); #124
1130INSERT INTO Writers (Name) VALUES ('Wolfgang Petersen'); #125
1131INSERT INTO Writers (Name) VALUES ('Yasuhiko Takiguchi'); #126
1132
1133SELECT * FROM Writers ORDER BY ID ASC;
1134
1135#################################################################################### INSERT MovieGenres
1136
1137INSERT INTO MovieGenres (MovieID,GenreID) VALUES (1,1); # Aliens is Action
1138INSERT INTO MovieGenres (MovieID,GenreID) VALUES (1,2); # Aliens is Adventure
1139INSERT INTO MovieGenres (MovieID,GenreID) VALUES (1,17); # Aliens is Sci-Fi
1140INSERT INTO MovieGenres (MovieID,GenreID) VALUES (1,19); # Aliens is Thriller
1141INSERT INTO MovieGenres (MovieID,GenreID) VALUES (2,7); # One Flew Over the Cuckoo\'s Nest is Drama
1142INSERT INTO MovieGenres (MovieID,GenreID) VALUES (3,5); # The Kid is Comedy
1143INSERT INTO MovieGenres (MovieID,GenreID) VALUES (3,7); # The Kid is Drama
1144INSERT INTO MovieGenres (MovieID,GenreID) VALUES (3,8); # The Kid is Family
1145INSERT INTO MovieGenres (MovieID,GenreID) VALUES (4,5); # Life Is Beautiful is Comedy
1146INSERT INTO MovieGenres (MovieID,GenreID) VALUES (4,7); # Life Is Beautiful is Drama
1147INSERT INTO MovieGenres (MovieID,GenreID) VALUES (4,16); # Life Is Beautiful is Romance
1148INSERT INTO MovieGenres (MovieID,GenreID) VALUES (4,20); # Life Is Beautiful is War
1149INSERT INTO MovieGenres (MovieID,GenreID) VALUES (5,2); # Princess Mononoke is Adventure
1150INSERT INTO MovieGenres (MovieID,GenreID) VALUES (5,3); # Princess Mononoke is Animation
1151INSERT INTO MovieGenres (MovieID,GenreID) VALUES (5,9); # Princess Mononoke is Fantasy
1152INSERT INTO MovieGenres (MovieID,GenreID) VALUES (6,6); # Witness for the Prosecution is Crime
1153INSERT INTO MovieGenres (MovieID,GenreID) VALUES (6,7); # Witness for the Prosecution is Drama
1154INSERT INTO MovieGenres (MovieID,GenreID) VALUES (6,10); # Witness for the Prosecution is Film-Noir
1155INSERT INTO MovieGenres (MovieID,GenreID) VALUES (6,15); # Witness for the Prosecution is Mystery
1156INSERT INTO MovieGenres (MovieID,GenreID) VALUES (6,19); # Witness for the Prosecution is Thriller
1157INSERT INTO MovieGenres (MovieID,GenreID) VALUES (7,6); # The Usual Suspects is Crime
1158INSERT INTO MovieGenres (MovieID,GenreID) VALUES (7,15); # The Usual Suspects is Mystery
1159INSERT INTO MovieGenres (MovieID,GenreID) VALUES (7,19); # The Usual Suspects is Thriller
1160INSERT INTO MovieGenres (MovieID,GenreID) VALUES (8,4); # The Pianist is Biography
1161INSERT INTO MovieGenres (MovieID,GenreID) VALUES (8,7); # The Pianist is Drama
1162INSERT INTO MovieGenres (MovieID,GenreID) VALUES (8,13); # The Pianist is Music
1163INSERT INTO MovieGenres (MovieID,GenreID) VALUES (8,20); # The Pianist is War
1164INSERT INTO MovieGenres (MovieID,GenreID) VALUES (9,1); # Avengers: Infinity War is Action
1165INSERT INTO MovieGenres (MovieID,GenreID) VALUES (9,2); # Avengers: Infinity War is Adventure
1166INSERT INTO MovieGenres (MovieID,GenreID) VALUES (9,17); # Avengers: Infinity War is Sci-Fi
1167INSERT INTO MovieGenres (MovieID,GenreID) VALUES (9,20); # Avengers: Infinity War is War
1168INSERT INTO MovieGenres (MovieID,GenreID) VALUES (10,2); # The Lord of the Rings: The Return of the King is Adventure
1169INSERT INTO MovieGenres (MovieID,GenreID) VALUES (10,7); # The Lord of the Rings: The Return of the King is Drama
1170INSERT INTO MovieGenres (MovieID,GenreID) VALUES (10,9); # The Lord of the Rings: The Return of the King is Fantasy
1171INSERT INTO MovieGenres (MovieID,GenreID) VALUES (11,5); # Amélie is Comedy
1172INSERT INTO MovieGenres (MovieID,GenreID) VALUES (11,16); # Amélie is Romance
1173INSERT INTO MovieGenres (MovieID,GenreID) VALUES (12,1); # The Matrix is Action
1174INSERT INTO MovieGenres (MovieID,GenreID) VALUES (12,17); # The Matrix is Sci-Fi
1175INSERT INTO MovieGenres (MovieID,GenreID) VALUES (13,2); # 2001: A Space Odyssey is Adventure
1176INSERT INTO MovieGenres (MovieID,GenreID) VALUES (13,17); # 2001: A Space Odyssey is Sci-Fi
1177INSERT INTO MovieGenres (MovieID,GenreID) VALUES (14,2); # The Lord of the Rings: The Two Towers is Adventure
1178INSERT INTO MovieGenres (MovieID,GenreID) VALUES (14,7); # The Lord of the Rings: The Two Towers is Drama
1179INSERT INTO MovieGenres (MovieID,GenreID) VALUES (14,9); # The Lord of the Rings: The Two Towers is Fantasy
1180INSERT INTO MovieGenres (MovieID,GenreID) VALUES (15,1); # Star Wars: Episode V - The Empire Strikes Back is Action
1181INSERT INTO MovieGenres (MovieID,GenreID) VALUES (15,2); # Star Wars: Episode V - The Empire Strikes Back is Adventure
1182INSERT INTO MovieGenres (MovieID,GenreID) VALUES (15,9); # Star Wars: Episode V - The Empire Strikes Back is Fantasy
1183INSERT INTO MovieGenres (MovieID,GenreID) VALUES (15,17); # Star Wars: Episode V - The Empire Strikes Back is Sci-Fi
1184INSERT INTO MovieGenres (MovieID,GenreID) VALUES (15,20); # Star Wars: Episode V - The Empire Strikes Back is War
1185INSERT INTO MovieGenres (MovieID,GenreID) VALUES (16,7); # Apocalypse Now is Drama
1186INSERT INTO MovieGenres (MovieID,GenreID) VALUES (16,15); # Apocalypse Now is Mystery
1187INSERT INTO MovieGenres (MovieID,GenreID) VALUES (16,20); # Apocalypse Now is War
1188INSERT INTO MovieGenres (MovieID,GenreID) VALUES (17,2); # North by Northwest is Adventure
1189INSERT INTO MovieGenres (MovieID,GenreID) VALUES (17,15); # North by Northwest is Mystery
1190INSERT INTO MovieGenres (MovieID,GenreID) VALUES (17,19); # North by Northwest is Thriller
1191INSERT INTO MovieGenres (MovieID,GenreID) VALUES (18,7); # The Shining is Drama
1192INSERT INTO MovieGenres (MovieID,GenreID) VALUES (18,12); # The Shining is Horror
1193INSERT INTO MovieGenres (MovieID,GenreID) VALUES (19,5); # 3 Idiots is Comedy
1194INSERT INTO MovieGenres (MovieID,GenreID) VALUES (19,7); # 3 Idiots is Drama
1195INSERT INTO MovieGenres (MovieID,GenreID) VALUES (20,1); # Avengers: Endgame is Action
1196INSERT INTO MovieGenres (MovieID,GenreID) VALUES (20,2); # Avengers: Endgame is Adventure
1197INSERT INTO MovieGenres (MovieID,GenreID) VALUES (20,7); # Avengers: Endgame is Drama
1198INSERT INTO MovieGenres (MovieID,GenreID) VALUES (20,17); # Avengers: Endgame is Sci-Fi
1199INSERT INTO MovieGenres (MovieID,GenreID) VALUES (21,6); # Once Upon a Time in America is Crime
1200INSERT INTO MovieGenres (MovieID,GenreID) VALUES (21,7); # Once Upon a Time in America is Drama
1201INSERT INTO MovieGenres (MovieID,GenreID) VALUES (22,1); # The Dark Knight is Action
1202INSERT INTO MovieGenres (MovieID,GenreID) VALUES (22,6); # The Dark Knight is Crime
1203INSERT INTO MovieGenres (MovieID,GenreID) VALUES (22,7); # The Dark Knight is Drama
1204INSERT INTO MovieGenres (MovieID,GenreID) VALUES (22,19); # The Dark Knight is Thriller
1205INSERT INTO MovieGenres (MovieID,GenreID) VALUES (23,4); # Untouchable is Biography
1206INSERT INTO MovieGenres (MovieID,GenreID) VALUES (23,5); # Untouchable is Comedy
1207INSERT INTO MovieGenres (MovieID,GenreID) VALUES (23,7); # Untouchable is Drama
1208INSERT INTO MovieGenres (MovieID,GenreID) VALUES (24,7); # Casablanca is Drama
1209INSERT INTO MovieGenres (MovieID,GenreID) VALUES (24,16); # Casablanca is Romance
1210INSERT INTO MovieGenres (MovieID,GenreID) VALUES (24,20); # Casablanca is War
1211INSERT INTO MovieGenres (MovieID,GenreID) VALUES (25,15); # Vertigo is Mystery
1212INSERT INTO MovieGenres (MovieID,GenreID) VALUES (25,16); # Vertigo is Romance
1213INSERT INTO MovieGenres (MovieID,GenreID) VALUES (25,19); # Vertigo is Thriller
1214INSERT INTO MovieGenres (MovieID,GenreID) VALUES (26,2); # Interstellar is Adventure
1215INSERT INTO MovieGenres (MovieID,GenreID) VALUES (26,7); # Interstellar is Drama
1216INSERT INTO MovieGenres (MovieID,GenreID) VALUES (26,17); # Interstellar is Sci-Fi
1217INSERT INTO MovieGenres (MovieID,GenreID) VALUES (27,1); # Harakiri is Action
1218INSERT INTO MovieGenres (MovieID,GenreID) VALUES (27,7); # Harakiri is Drama
1219INSERT INTO MovieGenres (MovieID,GenreID) VALUES (27,11); # Harakiri is History
1220INSERT INTO MovieGenres (MovieID,GenreID) VALUES (28,1); # Star Wars: Episode IV - A New Hope is Action
1221INSERT INTO MovieGenres (MovieID,GenreID) VALUES (28,2); # Star Wars: Episode IV - A New Hope is Adventure
1222INSERT INTO MovieGenres (MovieID,GenreID) VALUES (28,9); # Star Wars: Episode IV - A New Hope is Fantasy
1223INSERT INTO MovieGenres (MovieID,GenreID) VALUES (28,17); # Star Wars: Episode IV - A New Hope is Sci-Fi
1224INSERT INTO MovieGenres (MovieID,GenreID) VALUES (28,20); # Star Wars: Episode IV - A New Hope is War
1225INSERT INTO MovieGenres (MovieID,GenreID) VALUES (29,7); # Good Will Hunting is Drama
1226INSERT INTO MovieGenres (MovieID,GenreID) VALUES (29,16); # Good Will Hunting is Romance
1227INSERT INTO MovieGenres (MovieID,GenreID) VALUES (30,1); # Dangal is Action
1228INSERT INTO MovieGenres (MovieID,GenreID) VALUES (30,4); # Dangal is Biography
1229INSERT INTO MovieGenres (MovieID,GenreID) VALUES (30,7); # Dangal is Drama
1230INSERT INTO MovieGenres (MovieID,GenreID) VALUES (30,18); # Dangal is Sport
1231INSERT INTO MovieGenres (MovieID,GenreID) VALUES (31,6); # A Clockwork Orange is Crime
1232INSERT INTO MovieGenres (MovieID,GenreID) VALUES (31,7); # A Clockwork Orange is Drama
1233INSERT INTO MovieGenres (MovieID,GenreID) VALUES (31,17); # A Clockwork Orange is Sci-Fi
1234INSERT INTO MovieGenres (MovieID,GenreID) VALUES (32,7); # Eternal Sunshine of the Spotless Mind is Drama
1235INSERT INTO MovieGenres (MovieID,GenreID) VALUES (32,16); # Eternal Sunshine of the Spotless Mind is Romance
1236INSERT INTO MovieGenres (MovieID,GenreID) VALUES (32,17); # Eternal Sunshine of the Spotless Mind is Sci-Fi
1237INSERT INTO MovieGenres (MovieID,GenreID) VALUES (33,2); # Coco is Adventure
1238INSERT INTO MovieGenres (MovieID,GenreID) VALUES (33,3); # Coco is Animation
1239INSERT INTO MovieGenres (MovieID,GenreID) VALUES (33,8); # Coco is Family
1240INSERT INTO MovieGenres (MovieID,GenreID) VALUES (33,9); # Coco is Fantasy
1241INSERT INTO MovieGenres (MovieID,GenreID) VALUES (33,13); # Coco is Music
1242INSERT INTO MovieGenres (MovieID,GenreID) VALUES (33,15); # Coco is Mystery
1243INSERT INTO MovieGenres (MovieID,GenreID) VALUES (34,7); # Like Stars on Earth is Drama
1244INSERT INTO MovieGenres (MovieID,GenreID) VALUES (34,8); # Like Stars on Earth is Family
1245INSERT INTO MovieGenres (MovieID,GenreID) VALUES (35,7); # 12 Angry Men is Drama
1246INSERT INTO MovieGenres (MovieID,GenreID) VALUES (36,6); # The Departed is Crime
1247INSERT INTO MovieGenres (MovieID,GenreID) VALUES (36,7); # The Departed is Drama
1248INSERT INTO MovieGenres (MovieID,GenreID) VALUES (36,19); # The Departed is Thriller
1249INSERT INTO MovieGenres (MovieID,GenreID) VALUES (37,1); # Inception is Action
1250INSERT INTO MovieGenres (MovieID,GenreID) VALUES (37,2); # Inception is Adventure
1251INSERT INTO MovieGenres (MovieID,GenreID) VALUES (37,17); # Inception is Sci-Fi
1252INSERT INTO MovieGenres (MovieID,GenreID) VALUES (37,19); # Inception is Thriller
1253INSERT INTO MovieGenres (MovieID,GenreID) VALUES (38,7); # The Hunt is Drama
1254INSERT INTO MovieGenres (MovieID,GenreID) VALUES (39,7); # Requiem for a Dream is Drama
1255INSERT INTO MovieGenres (MovieID,GenreID) VALUES (40,2); # WALL·E is Adventure
1256INSERT INTO MovieGenres (MovieID,GenreID) VALUES (40,3); # WALL·E is Animation
1257INSERT INTO MovieGenres (MovieID,GenreID) VALUES (40,8); # WALL·E is Family
1258INSERT INTO MovieGenres (MovieID,GenreID) VALUES (40,17); # WALL·E is Sci-Fi
1259INSERT INTO MovieGenres (MovieID,GenreID) VALUES (41,7); # It\'s a Wonderful Life is Drama
1260INSERT INTO MovieGenres (MovieID,GenreID) VALUES (41,8); # It\'s a Wonderful Life is Family
1261INSERT INTO MovieGenres (MovieID,GenreID) VALUES (41,9); # It\'s a Wonderful Life is Fantasy
1262INSERT INTO MovieGenres (MovieID,GenreID) VALUES (42,12); # Alien is Horror
1263INSERT INTO MovieGenres (MovieID,GenreID) VALUES (42,17); # Alien is Sci-Fi
1264INSERT INTO MovieGenres (MovieID,GenreID) VALUES (43,7); # American History X is Drama
1265INSERT INTO MovieGenres (MovieID,GenreID) VALUES (43,11); # American History X is History
1266INSERT INTO MovieGenres (MovieID,GenreID) VALUES (44,2); # Toy Story is Adventure
1267INSERT INTO MovieGenres (MovieID,GenreID) VALUES (44,3); # Toy Story is Animation
1268INSERT INTO MovieGenres (MovieID,GenreID) VALUES (44,5); # Toy Story is Comedy
1269INSERT INTO MovieGenres (MovieID,GenreID) VALUES (44,8); # Toy Story is Family
1270INSERT INTO MovieGenres (MovieID,GenreID) VALUES (44,9); # Toy Story is Fantasy
1271INSERT INTO MovieGenres (MovieID,GenreID) VALUES (45,1); # Seven Samurai is Action
1272INSERT INTO MovieGenres (MovieID,GenreID) VALUES (45,2); # Seven Samurai is Adventure
1273INSERT INTO MovieGenres (MovieID,GenreID) VALUES (45,7); # Seven Samurai is Drama
1274INSERT INTO MovieGenres (MovieID,GenreID) VALUES (46,5); # Modern Times is Comedy
1275INSERT INTO MovieGenres (MovieID,GenreID) VALUES (46,7); # Modern Times is Drama
1276INSERT INTO MovieGenres (MovieID,GenreID) VALUES (46,8); # Modern Times is Family
1277INSERT INTO MovieGenres (MovieID,GenreID) VALUES (46,16); # Modern Times is Romance
1278INSERT INTO MovieGenres (MovieID,GenreID) VALUES (47,6); # The Green Mile is Crime
1279INSERT INTO MovieGenres (MovieID,GenreID) VALUES (47,7); # The Green Mile is Drama
1280INSERT INTO MovieGenres (MovieID,GenreID) VALUES (47,9); # The Green Mile is Fantasy
1281INSERT INTO MovieGenres (MovieID,GenreID) VALUES (47,15); # The Green Mile is Mystery
1282INSERT INTO MovieGenres (MovieID,GenreID) VALUES (48,4); # Schindler\'s List is Biography
1283INSERT INTO MovieGenres (MovieID,GenreID) VALUES (48,7); # Schindler\'s List is Drama
1284INSERT INTO MovieGenres (MovieID,GenreID) VALUES (48,11); # Schindler\'s List is History
1285INSERT INTO MovieGenres (MovieID,GenreID) VALUES (49,15); # Rear Window is Mystery
1286INSERT INTO MovieGenres (MovieID,GenreID) VALUES (49,19); # Rear Window is Thriller
1287INSERT INTO MovieGenres (MovieID,GenreID) VALUES (50,7); # Full Metal Jacket is Drama
1288INSERT INTO MovieGenres (MovieID,GenreID) VALUES (50,20); # Full Metal Jacket is War
1289INSERT INTO MovieGenres (MovieID,GenreID) VALUES (51,5); # City Lights is Comedy
1290INSERT INTO MovieGenres (MovieID,GenreID) VALUES (51,7); # City Lights is Drama
1291INSERT INTO MovieGenres (MovieID,GenreID) VALUES (51,16); # City Lights is Romance
1292INSERT INTO MovieGenres (MovieID,GenreID) VALUES (52,5); # The Great Dictator is Comedy
1293INSERT INTO MovieGenres (MovieID,GenreID) VALUES (52,7); # The Great Dictator is Drama
1294INSERT INTO MovieGenres (MovieID,GenreID) VALUES (52,20); # The Great Dictator is War
1295INSERT INTO MovieGenres (MovieID,GenreID) VALUES (53,6); # M is Crime
1296INSERT INTO MovieGenres (MovieID,GenreID) VALUES (53,15); # M is Mystery
1297INSERT INTO MovieGenres (MovieID,GenreID) VALUES (53,19); # M is Thriller
1298INSERT INTO MovieGenres (MovieID,GenreID) VALUES (54,3); # Grave of the Fireflies is Animation
1299INSERT INTO MovieGenres (MovieID,GenreID) VALUES (54,20); # Grave of the Fireflies is War
1300INSERT INTO MovieGenres (MovieID,GenreID) VALUES (55,6); # The Silence of the Lambs is Crime
1301INSERT INTO MovieGenres (MovieID,GenreID) VALUES (55,7); # The Silence of the Lambs is Drama
1302INSERT INTO MovieGenres (MovieID,GenreID) VALUES (55,19); # The Silence of the Lambs is Thriller
1303INSERT INTO MovieGenres (MovieID,GenreID) VALUES (56,1); # Gladiator is Action
1304INSERT INTO MovieGenres (MovieID,GenreID) VALUES (56,2); # Gladiator is Adventure
1305INSERT INTO MovieGenres (MovieID,GenreID) VALUES (56,7); # Gladiator is Drama
1306INSERT INTO MovieGenres (MovieID,GenreID) VALUES (57,2); # Back to the Future is Adventure
1307INSERT INTO MovieGenres (MovieID,GenreID) VALUES (57,5); # Back to the Future is Comedy
1308INSERT INTO MovieGenres (MovieID,GenreID) VALUES (57,17); # Back to the Future is Sci-Fi
1309INSERT INTO MovieGenres (MovieID,GenreID) VALUES (58,4); # Braveheart is Biography
1310INSERT INTO MovieGenres (MovieID,GenreID) VALUES (58,7); # Braveheart is Drama
1311INSERT INTO MovieGenres (MovieID,GenreID) VALUES (58,11); # Braveheart is History
1312INSERT INTO MovieGenres (MovieID,GenreID) VALUES (58,20); # Braveheart is War
1313INSERT INTO MovieGenres (MovieID,GenreID) VALUES (59,1); # Leon is Action
1314INSERT INTO MovieGenres (MovieID,GenreID) VALUES (59,6); # Leon is Crime
1315INSERT INTO MovieGenres (MovieID,GenreID) VALUES (59,7); # Leon is Drama
1316INSERT INTO MovieGenres (MovieID,GenreID) VALUES (59,19); # Leon is Thriller
1317INSERT INTO MovieGenres (MovieID,GenreID) VALUES (60,2); # Inglourious Basterds is Adventure
1318INSERT INTO MovieGenres (MovieID,GenreID) VALUES (60,7); # Inglourious Basterds is Drama
1319INSERT INTO MovieGenres (MovieID,GenreID) VALUES (60,20); # Inglourious Basterds is War
1320INSERT INTO MovieGenres (MovieID,GenreID) VALUES (61,7); # The Shawshank Redemption is Drama
1321INSERT INTO MovieGenres (MovieID,GenreID) VALUES (62,1); # Oldboy is Action
1322INSERT INTO MovieGenres (MovieID,GenreID) VALUES (62,7); # Oldboy is Drama
1323INSERT INTO MovieGenres (MovieID,GenreID) VALUES (62,15); # Oldboy is Mystery
1324INSERT INTO MovieGenres (MovieID,GenreID) VALUES (62,19); # Oldboy is Thriller
1325INSERT INTO MovieGenres (MovieID,GenreID) VALUES (63,6); # City of God is Crime
1326INSERT INTO MovieGenres (MovieID,GenreID) VALUES (63,7); # City of God is Drama
1327INSERT INTO MovieGenres (MovieID,GenreID) VALUES (64,7); # Forrest Gump is Drama
1328INSERT INTO MovieGenres (MovieID,GenreID) VALUES (64,16); # Forrest Gump is Romance
1329INSERT INTO MovieGenres (MovieID,GenreID) VALUES (65,6); # Reservoir Dogs is Crime
1330INSERT INTO MovieGenres (MovieID,GenreID) VALUES (65,7); # Reservoir Dogs is Drama
1331INSERT INTO MovieGenres (MovieID,GenreID) VALUES (65,19); # Reservoir Dogs is Thriller
1332INSERT INTO MovieGenres (MovieID,GenreID) VALUES (66,1); # The Lord of the Rings: The Fellowship of the Ring is Action
1333INSERT INTO MovieGenres (MovieID,GenreID) VALUES (66,2); # The Lord of the Rings: The Fellowship of the Ring is Adventure
1334INSERT INTO MovieGenres (MovieID,GenreID) VALUES (66,7); # The Lord of the Rings: The Fellowship of the Ring is Drama
1335INSERT INTO MovieGenres (MovieID,GenreID) VALUES (66,9); # The Lord of the Rings: The Fellowship of the Ring is Fantasy
1336INSERT INTO MovieGenres (MovieID,GenreID) VALUES (67,6); # Joker is Crime
1337INSERT INTO MovieGenres (MovieID,GenreID) VALUES (67,7); # Joker is Drama
1338INSERT INTO MovieGenres (MovieID,GenreID) VALUES (67,19); # Joker is Thriller
1339INSERT INTO MovieGenres (MovieID,GenreID) VALUES (68,15); # Memento is Mystery
1340INSERT INTO MovieGenres (MovieID,GenreID) VALUES (68,19); # Memento is Thriller
1341INSERT INTO MovieGenres (MovieID,GenreID) VALUES (69,7); # The Prestige is Drama
1342INSERT INTO MovieGenres (MovieID,GenreID) VALUES (69,15); # The Prestige is Mystery
1343INSERT INTO MovieGenres (MovieID,GenreID) VALUES (69,17); # The Prestige is Sci-Fi
1344INSERT INTO MovieGenres (MovieID,GenreID) VALUES (69,19); # The Prestige is Thriller
1345INSERT INTO MovieGenres (MovieID,GenreID) VALUES (70,3); # Your Name. is Animation
1346INSERT INTO MovieGenres (MovieID,GenreID) VALUES (70,7); # Your Name. is Drama
1347INSERT INTO MovieGenres (MovieID,GenreID) VALUES (70,9); # Your Name. is Fantasy
1348INSERT INTO MovieGenres (MovieID,GenreID) VALUES (70,16); # Your Name. is Romance
1349INSERT INTO MovieGenres (MovieID,GenreID) VALUES (71,7); # American Beauty is Drama
1350INSERT INTO MovieGenres (MovieID,GenreID) VALUES (72,7); # The Lives of Others is Drama
1351INSERT INTO MovieGenres (MovieID,GenreID) VALUES (72,15); # The Lives of Others is Mystery
1352INSERT INTO MovieGenres (MovieID,GenreID) VALUES (72,19); # The Lives of Others is Thriller
1353INSERT INTO MovieGenres (MovieID,GenreID) VALUES (73,7); # Saving Private Ryan is Drama
1354INSERT INTO MovieGenres (MovieID,GenreID) VALUES (73,20); # Saving Private Ryan is War
1355INSERT INTO MovieGenres (MovieID,GenreID) VALUES (74,1); # Raiders of the Lost Ark is Action
1356INSERT INTO MovieGenres (MovieID,GenreID) VALUES (74,2); # Raiders of the Lost Ark is Adventure
1357INSERT INTO MovieGenres (MovieID,GenreID) VALUES (75,21); # Once Upon a Time in the West is Western
1358INSERT INTO MovieGenres (MovieID,GenreID) VALUES (76,6); # The Godfather is Crime
1359INSERT INTO MovieGenres (MovieID,GenreID) VALUES (76,7); # The Godfather is Drama
1360INSERT INTO MovieGenres (MovieID,GenreID) VALUES (77,1); # Terminator 2: Judgment Day is Action
1361INSERT INTO MovieGenres (MovieID,GenreID) VALUES (77,17); # Terminator 2: Judgment Day is Sci-Fi
1362INSERT INTO MovieGenres (MovieID,GenreID) VALUES (78,2); # The Lion King is Adventure
1363INSERT INTO MovieGenres (MovieID,GenreID) VALUES (78,3); # The Lion King is Animation
1364INSERT INTO MovieGenres (MovieID,GenreID) VALUES (78,7); # The Lion King is Drama
1365INSERT INTO MovieGenres (MovieID,GenreID) VALUES (78,8); # The Lion King is Family
1366INSERT INTO MovieGenres (MovieID,GenreID) VALUES (78,13); # The Lion King is Music
1367INSERT INTO MovieGenres (MovieID,GenreID) VALUES (78,14); # The Lion King is Musical
1368INSERT INTO MovieGenres (MovieID,GenreID) VALUES (79,1); # Star Wars: Episode VI - Return of the Jedi is Action
1369INSERT INTO MovieGenres (MovieID,GenreID) VALUES (79,2); # Star Wars: Episode VI - Return of the Jedi is Adventure
1370INSERT INTO MovieGenres (MovieID,GenreID) VALUES (79,9); # Star Wars: Episode VI - Return of the Jedi is Fantasy
1371INSERT INTO MovieGenres (MovieID,GenreID) VALUES (79,17); # Star Wars: Episode VI - Return of the Jedi is Sci-Fi
1372INSERT INTO MovieGenres (MovieID,GenreID) VALUES (79,20); # Star Wars: Episode VI - Return of the Jedi is War
1373INSERT INTO MovieGenres (MovieID,GenreID) VALUES (80,6); # Seven is Crime
1374INSERT INTO MovieGenres (MovieID,GenreID) VALUES (80,7); # Seven is Drama
1375INSERT INTO MovieGenres (MovieID,GenreID) VALUES (80,15); # Seven is Mystery
1376INSERT INTO MovieGenres (MovieID,GenreID) VALUES (80,19); # Seven is Thriller
1377INSERT INTO MovieGenres (MovieID,GenreID) VALUES (81,7); # Sunset Blvd. is Drama
1378INSERT INTO MovieGenres (MovieID,GenreID) VALUES (81,10); # Sunset Blvd. is Film-Noir
1379INSERT INTO MovieGenres (MovieID,GenreID) VALUES (82,2); # Spirited Away is Adventure
1380INSERT INTO MovieGenres (MovieID,GenreID) VALUES (82,3); # Spirited Away is Animation
1381INSERT INTO MovieGenres (MovieID,GenreID) VALUES (82,8); # Spirited Away is Family
1382INSERT INTO MovieGenres (MovieID,GenreID) VALUES (82,9); # Spirited Away is Fantasy
1383INSERT INTO MovieGenres (MovieID,GenreID) VALUES (82,15); # Spirited Away is Mystery
1384INSERT INTO MovieGenres (MovieID,GenreID) VALUES (83,6); # Pulp Fiction is Crime
1385INSERT INTO MovieGenres (MovieID,GenreID) VALUES (83,7); # Pulp Fiction is Drama
1386INSERT INTO MovieGenres (MovieID,GenreID) VALUES (84,5); # Snatch is Comedy
1387INSERT INTO MovieGenres (MovieID,GenreID) VALUES (84,6); # Snatch is Crime
1388INSERT INTO MovieGenres (MovieID,GenreID) VALUES (85,7); # Fight Club is Drama
1389INSERT INTO MovieGenres (MovieID,GenreID) VALUES (86,12); # Psycho is Horror
1390INSERT INTO MovieGenres (MovieID,GenreID) VALUES (86,15); # Psycho is Mystery
1391INSERT INTO MovieGenres (MovieID,GenreID) VALUES (86,19); # Psycho is Thriller
1392INSERT INTO MovieGenres (MovieID,GenreID) VALUES (87,7); # Citizen Kane is Drama
1393INSERT INTO MovieGenres (MovieID,GenreID) VALUES (87,15); # Citizen Kane is Mystery
1394INSERT INTO MovieGenres (MovieID,GenreID) VALUES (88,2); # Das Boot is Adventure
1395INSERT INTO MovieGenres (MovieID,GenreID) VALUES (88,7); # Das Boot is Drama
1396INSERT INTO MovieGenres (MovieID,GenreID) VALUES (88,19); # Das Boot is Thriller
1397INSERT INTO MovieGenres (MovieID,GenreID) VALUES (88,20); # Das Boot is War
1398INSERT INTO MovieGenres (MovieID,GenreID) VALUES (89,7); # Paths of Glory is Drama
1399INSERT INTO MovieGenres (MovieID,GenreID) VALUES (89,20); # Paths of Glory is War
1400INSERT INTO MovieGenres (MovieID,GenreID) VALUES (90,1); # Spider-Man: Into the Spider-Verse is Action
1401INSERT INTO MovieGenres (MovieID,GenreID) VALUES (90,2); # Spider-Man: Into the Spider-Verse is Adventure
1402INSERT INTO MovieGenres (MovieID,GenreID) VALUES (90,3); # Spider-Man: Into the Spider-Verse is Animation
1403INSERT INTO MovieGenres (MovieID,GenreID) VALUES (90,8); # Spider-Man: Into the Spider-Verse is Family
1404INSERT INTO MovieGenres (MovieID,GenreID) VALUES (90,17); # Spider-Man: Into the Spider-Verse is Sci-Fi
1405INSERT INTO MovieGenres (MovieID,GenreID) VALUES (91,4); # Amadeus is Biography
1406INSERT INTO MovieGenres (MovieID,GenreID) VALUES (91,7); # Amadeus is Drama
1407INSERT INTO MovieGenres (MovieID,GenreID) VALUES (91,11); # Amadeus is History
1408INSERT INTO MovieGenres (MovieID,GenreID) VALUES (91,13); # Amadeus is Music
1409INSERT INTO MovieGenres (MovieID,GenreID) VALUES (92,7); # Django Unchained is Drama
1410INSERT INTO MovieGenres (MovieID,GenreID) VALUES (92,21); # Django Unchained is Western
1411INSERT INTO MovieGenres (MovieID,GenreID) VALUES (93,21); # The Good, the Bad and the Ugly is Western
1412INSERT INTO MovieGenres (MovieID,GenreID) VALUES (94,4); # Goodfellas is Biography
1413INSERT INTO MovieGenres (MovieID,GenreID) VALUES (94,6); # Goodfellas is Crime
1414INSERT INTO MovieGenres (MovieID,GenreID) VALUES (94,7); # Goodfellas is Drama
1415INSERT INTO MovieGenres (MovieID,GenreID) VALUES (95,7); # Whiplash is Drama
1416INSERT INTO MovieGenres (MovieID,GenreID) VALUES (95,13); # Whiplash is Music
1417INSERT INTO MovieGenres (MovieID,GenreID) VALUES (96,6); # The Godfather: Part II is Crime
1418INSERT INTO MovieGenres (MovieID,GenreID) VALUES (96,7); # The Godfather: Part II is Drama
1419INSERT INTO MovieGenres (MovieID,GenreID) VALUES (97,5); # Parasite is Comedy
1420INSERT INTO MovieGenres (MovieID,GenreID) VALUES (97,7); # Parasite is Drama
1421INSERT INTO MovieGenres (MovieID,GenreID) VALUES (97,19); # Parasite is Thriller
1422INSERT INTO MovieGenres (MovieID,GenreID) VALUES (98,5); # Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb is Comedy
1423INSERT INTO MovieGenres (MovieID,GenreID) VALUES (99,7); # Cinema Paradiso is Drama
1424INSERT INTO MovieGenres (MovieID,GenreID) VALUES (100,1); # The Dark Knight Rises is Action
1425INSERT INTO MovieGenres (MovieID,GenreID) VALUES (100,2); # The Dark Knight Rises is Adventure
1426
1427SELECT * FROM MovieGenres ORDER BY MovieID ASC;
1428
1429#################################################################################### INSERT MovieWriters
1430
1431INSERT INTO MovieWriters (MovieID,WriterID) VALUES (1,31); # Aliens was written by David Giler
1432INSERT INTO MovieWriters (MovieID,WriterID) VALUES (1,53); # Aliens was written by James Cameron
1433INSERT INTO MovieWriters (MovieID,WriterID) VALUES (2,15); # One Flew Over the Cuckoo\'s Nest was written by Bo Goldman
1434INSERT INTO MovieWriters (MovieID,WriterID) VALUES (2,65); # One Flew Over the Cuckoo\'s Nest was written by Lawrence Hauben
1435INSERT INTO MovieWriters (MovieID,WriterID) VALUES (3,21); # The Kid was written by Charles Chaplin
1436INSERT INTO MovieWriters (MovieID,WriterID) VALUES (4,98); # Life Is Beautiful was written by Roberto Benigni
1437INSERT INTO MovieWriters (MovieID,WriterID) VALUES (4,120); # Life Is Beautiful was written by Vincenzo Cerami
1438INSERT INTO MovieWriters (MovieID,WriterID) VALUES (5,47); # Princess Mononoke was written by Hayao Miyazaki
1439INSERT INTO MovieWriters (MovieID,WriterID) VALUES (5,79); # Princess Mononoke was written by Neil Gaiman (adapted by: English version)
1440INSERT INTO MovieWriters (MovieID,WriterID) VALUES (6,2); # Witness for the Prosecution was written by Agatha Christie (in Agatha Christie\'s international stage success)
1441INSERT INTO MovieWriters (MovieID,WriterID) VALUES (6,14); # Witness for the Prosecution was written by Billy Wilder
1442INSERT INTO MovieWriters (MovieID,WriterID) VALUES (7,24); # The Usual Suspects was written by Christopher McQuarrie
1443INSERT INTO MovieWriters (MovieID,WriterID) VALUES (8,101); # The Pianist was written by Ronald Harwood
1444INSERT INTO MovieWriters (MovieID,WriterID) VALUES (8,124); # The Pianist was written by Wladyslaw Szpilman
1445INSERT INTO MovieWriters (MovieID,WriterID) VALUES (9,23); # Avengers: Infinity War was written by Christopher Markus
1446INSERT INTO MovieWriters (MovieID,WriterID) VALUES (9,110); # Avengers: Infinity War was written by Stephen McFeely
1447INSERT INTO MovieWriters (MovieID,WriterID) VALUES (10,36); # The Lord of the Rings: The Return of the King was written by Fran Walsh
1448INSERT INTO MovieWriters (MovieID,WriterID) VALUES (10,52); # The Lord of the Rings: The Return of the King was written by J.R.R. Tolkien
1449INSERT INTO MovieWriters (MovieID,WriterID) VALUES (11,44); # Amélie was written by Guillaume Laurant
1450INSERT INTO MovieWriters (MovieID,WriterID) VALUES (11,55); # Amélie was written by Jean-Pierre Jeunet
1451INSERT INTO MovieWriters (MovieID,WriterID) VALUES (12,64); # The Matrix was written by Lana Wachowski
1452INSERT INTO MovieWriters (MovieID,WriterID) VALUES (12,70); # The Matrix was written by Lilly Wachowski
1453INSERT INTO MovieWriters (MovieID,WriterID) VALUES (13,12); # 2001: A Space Odyssey was written by Arthur C. Clarke
1454INSERT INTO MovieWriters (MovieID,WriterID) VALUES (13,108); # 2001: A Space Odyssey was written by Stanley Kubrick
1455INSERT INTO MovieWriters (MovieID,WriterID) VALUES (14,36); # The Lord of the Rings: The Two Towers was written by Fran Walsh
1456INSERT INTO MovieWriters (MovieID,WriterID) VALUES (14,52); # The Lord of the Rings: The Two Towers was written by J.R.R. Tolkien
1457INSERT INTO MovieWriters (MovieID,WriterID) VALUES (15,66); # Star Wars: Episode V - The Empire Strikes Back was written by Lawrence Kasdan
1458INSERT INTO MovieWriters (MovieID,WriterID) VALUES (15,68); # Star Wars: Episode V - The Empire Strikes Back was written by Leigh Brackett
1459INSERT INTO MovieWriters (MovieID,WriterID) VALUES (16,38); # Apocalypse Now was written by Francis Ford Coppola
1460INSERT INTO MovieWriters (MovieID,WriterID) VALUES (16,59); # Apocalypse Now was written by John Milius
1461INSERT INTO MovieWriters (MovieID,WriterID) VALUES (17,34); # North by Northwest was written by Ernest Lehman
1462INSERT INTO MovieWriters (MovieID,WriterID) VALUES (18,108); # The Shining was written by Stanley Kubrick
1463INSERT INTO MovieWriters (MovieID,WriterID) VALUES (18,109); # The Shining was written by Stephen King
1464INSERT INTO MovieWriters (MovieID,WriterID) VALUES (19,1); # 3 Idiots was written by Abhijat Joshi
1465INSERT INTO MovieWriters (MovieID,WriterID) VALUES (19,92); # 3 Idiots was written by Rajkumar Hirani
1466INSERT INTO MovieWriters (MovieID,WriterID) VALUES (20,23); # Avengers: Endgame was written by Christopher Markus
1467INSERT INTO MovieWriters (MovieID,WriterID) VALUES (20,110); # Avengers: Endgame was written by Stephen McFeely
1468INSERT INTO MovieWriters (MovieID,WriterID) VALUES (21,46); # Once Upon a Time in America was written by Harry Grey
1469INSERT INTO MovieWriters (MovieID,WriterID) VALUES (21,69); # Once Upon a Time in America was written by Leonardo Benvenuti
1470INSERT INTO MovieWriters (MovieID,WriterID) VALUES (21,105); # Once Upon a Time in America was written by Sergio Leone
1471INSERT INTO MovieWriters (MovieID,WriterID) VALUES (22,25); # The Dark Knight was written by Christopher Nolan
1472INSERT INTO MovieWriters (MovieID,WriterID) VALUES (22,60); # The Dark Knight was written by Jonathan Nolan
1473INSERT INTO MovieWriters (MovieID,WriterID) VALUES (23,82); # Untouchable was written by Olivier Nakache
1474INSERT INTO MovieWriters (MovieID,WriterID) VALUES (23,89); # Untouchable was written by Philippe Pozzo di Borgo
1475INSERT INTO MovieWriters (MovieID,WriterID) VALUES (24,63); # Casablanca was written by Julius J. Epstein
1476INSERT INTO MovieWriters (MovieID,WriterID) VALUES (24,88); # Casablanca was written by Philip G. Epstein
1477INSERT INTO MovieWriters (MovieID,WriterID) VALUES (25,7); # Vertigo was written by Alec Coppel
1478INSERT INTO MovieWriters (MovieID,WriterID) VALUES (25,102); # Vertigo was written by Samuel A. Taylor
1479INSERT INTO MovieWriters (MovieID,WriterID) VALUES (26,25); # Interstellar was written by Christopher Nolan
1480INSERT INTO MovieWriters (MovieID,WriterID) VALUES (26,60); # Interstellar was written by Jonathan Nolan
1481INSERT INTO MovieWriters (MovieID,WriterID) VALUES (27,106); # Harakiri was written by Shinobu Hashimoto
1482INSERT INTO MovieWriters (MovieID,WriterID) VALUES (27,126); # Harakiri was written by Yasuhiko Takiguchi
1483INSERT INTO MovieWriters (MovieID,WriterID) VALUES (28,42); # Star Wars: Episode IV - A New Hope was written by George Lucas
1484INSERT INTO MovieWriters (MovieID,WriterID) VALUES (29,13); # Good Will Hunting was written by Ben Affleck
1485INSERT INTO MovieWriters (MovieID,WriterID) VALUES (29,76); # Good Will Hunting was written by Matt Damon
1486INSERT INTO MovieWriters (MovieID,WriterID) VALUES (30,90); # Dangal was written by Piyush Gupta
1487INSERT INTO MovieWriters (MovieID,WriterID) VALUES (30,107); # Dangal was written by Shreyas Jain
1488INSERT INTO MovieWriters (MovieID,WriterID) VALUES (31,11); # A Clockwork Orange was written by Anthony Burgess
1489INSERT INTO MovieWriters (MovieID,WriterID) VALUES (31,108); # A Clockwork Orange was written by Stanley Kubrick
1490INSERT INTO MovieWriters (MovieID,WriterID) VALUES (32,22); # Eternal Sunshine of the Spotless Mind was written by Charlie Kaufman
1491INSERT INTO MovieWriters (MovieID,WriterID) VALUES (32,78); # Eternal Sunshine of the Spotless Mind was written by Michel Gondry
1492INSERT INTO MovieWriters (MovieID,WriterID) VALUES (33,54); # Coco was written by Jason Katz
1493INSERT INTO MovieWriters (MovieID,WriterID) VALUES (33,67); # Coco was written by Lee Unkrich
1494INSERT INTO MovieWriters (MovieID,WriterID) VALUES (34,8); # Like Stars on Earth was written by Amole Gupte
1495INSERT INTO MovieWriters (MovieID,WriterID) VALUES (35,94); # 12 Angry Men was written by Reginald Rose
1496INSERT INTO MovieWriters (MovieID,WriterID) VALUES (36,5); # The Departed was written by Alan Mak
1497INSERT INTO MovieWriters (MovieID,WriterID) VALUES (36,76); # The Departed was written by Matt Damon
1498INSERT INTO MovieWriters (MovieID,WriterID) VALUES (36,121); # The Departed was written by William Monahan
1499INSERT INTO MovieWriters (MovieID,WriterID) VALUES (37,25); # Inception was written by Christopher Nolan
1500INSERT INTO MovieWriters (MovieID,WriterID) VALUES (38,117); # The Hunt was written by Thomas Vinterberg
1501INSERT INTO MovieWriters (MovieID,WriterID) VALUES (38,118); # The Hunt was written by Tobias Lindholm
1502INSERT INTO MovieWriters (MovieID,WriterID) VALUES (39,49); # Requiem for a Dream was written by Hubert Selby Jr.
1503INSERT INTO MovieWriters (MovieID,WriterID) VALUES (40,10); # WALL·E was written by Andrew Stanton
1504INSERT INTO MovieWriters (MovieID,WriterID) VALUES (40,85); # WALL·E was written by Pete Docter
1505INSERT INTO MovieWriters (MovieID,WriterID) VALUES (41,6); # It\'s a Wonderful Life was written by Albert Hackett
1506INSERT INTO MovieWriters (MovieID,WriterID) VALUES (41,37); # It\'s a Wonderful Life was written by Frances Goodrich
1507INSERT INTO MovieWriters (MovieID,WriterID) VALUES (42,29); # Alien was written by Dan O\'Bannon
1508INSERT INTO MovieWriters (MovieID,WriterID) VALUES (43,32); # American History X was written by David McKenna
1509INSERT INTO MovieWriters (MovieID,WriterID) VALUES (44,57); # Toy Story was written by John Lasseter
1510INSERT INTO MovieWriters (MovieID,WriterID) VALUES (44,85); # Toy Story was written by Pete Docter
1511INSERT INTO MovieWriters (MovieID,WriterID) VALUES (45,106); # Seven Samurai was written by Shinobu Hashimoto
1512INSERT INTO MovieWriters (MovieID,WriterID) VALUES (46,21); # Modern Times was written by Charles Chaplin
1513INSERT INTO MovieWriters (MovieID,WriterID) VALUES (47,39); # The Green Mile was written by Frank Darabont
1514INSERT INTO MovieWriters (MovieID,WriterID) VALUES (47,109); # The Green Mile was written by Stephen King
1515INSERT INTO MovieWriters (MovieID,WriterID) VALUES (48,111); # Schindler\'s List was written by Steven Zaillian
1516INSERT INTO MovieWriters (MovieID,WriterID) VALUES (48,116); # Schindler\'s List was written by Thomas Keneally
1517INSERT INTO MovieWriters (MovieID,WriterID) VALUES (49,27); # Rear Window was written by Cornell Woolrich
1518INSERT INTO MovieWriters (MovieID,WriterID) VALUES (49,58); # Rear Window was written by John Michael Hayes
1519INSERT INTO MovieWriters (MovieID,WriterID) VALUES (50,77); # Full Metal Jacket was written by Michael Herr
1520INSERT INTO MovieWriters (MovieID,WriterID) VALUES (50,108); # Full Metal Jacket was written by Stanley Kubrick
1521INSERT INTO MovieWriters (MovieID,WriterID) VALUES (51,21); # City Lights was written by Charles Chaplin
1522INSERT INTO MovieWriters (MovieID,WriterID) VALUES (52,21); # The Great Dictator was written by Charles Chaplin
1523INSERT INTO MovieWriters (MovieID,WriterID) VALUES (53,40); # M was written by Fritz Lang
1524INSERT INTO MovieWriters (MovieID,WriterID) VALUES (53,114); # M was written by Thea von Harbou
1525INSERT INTO MovieWriters (MovieID,WriterID) VALUES (54,3); # Grave of the Fireflies was written by Akiyuki Nosaka
1526INSERT INTO MovieWriters (MovieID,WriterID) VALUES (54,51); # Grave of the Fireflies was written by Isao Takahata
1527INSERT INTO MovieWriters (MovieID,WriterID) VALUES (55,112); # The Silence of the Lambs was written by Ted Tally
1528INSERT INTO MovieWriters (MovieID,WriterID) VALUES (55,115); # The Silence of the Lambs was written by Thomas Harris
1529INSERT INTO MovieWriters (MovieID,WriterID) VALUES (56,30); # Gladiator was written by David Franzoni
1530INSERT INTO MovieWriters (MovieID,WriterID) VALUES (57,16); # Back to the Future was written by Bob Gale
1531INSERT INTO MovieWriters (MovieID,WriterID) VALUES (57,97); # Back to the Future was written by Robert Zemeckis
1532INSERT INTO MovieWriters (MovieID,WriterID) VALUES (58,93); # Braveheart was written by Randall Wallace
1533INSERT INTO MovieWriters (MovieID,WriterID) VALUES (59,72); # Leon was written by Luc Besson
1534INSERT INTO MovieWriters (MovieID,WriterID) VALUES (60,91); # Inglourious Basterds was written by Quentin Tarantino
1535INSERT INTO MovieWriters (MovieID,WriterID) VALUES (61,39); # The Shawshank Redemption was written by Frank Darabont
1536INSERT INTO MovieWriters (MovieID,WriterID) VALUES (61,109); # The Shawshank Redemption was written by Stephen King
1537INSERT INTO MovieWriters (MovieID,WriterID) VALUES (62,41); # Oldboy was written by Garon Tsuchiya
1538INSERT INTO MovieWriters (MovieID,WriterID) VALUES (62,81); # Oldboy was written by Nobuaki Minegishi
1539INSERT INTO MovieWriters (MovieID,WriterID) VALUES (63,18); # City of God was written by Bráulio Mantovani
1540INSERT INTO MovieWriters (MovieID,WriterID) VALUES (63,84); # City of God was written by Paulo Lins
1541INSERT INTO MovieWriters (MovieID,WriterID) VALUES (64,33); # Forrest Gump was written by Eric Roth
1542INSERT INTO MovieWriters (MovieID,WriterID) VALUES (64,97); # Forrest Gump was written by Robert Zemeckis
1543INSERT INTO MovieWriters (MovieID,WriterID) VALUES (64,123); # Forrest Gump was written by Winston Groom
1544INSERT INTO MovieWriters (MovieID,WriterID) VALUES (65,91); # Reservoir Dogs was written by Quentin Tarantino
1545INSERT INTO MovieWriters (MovieID,WriterID) VALUES (66,36); # The Lord of the Rings: The Fellowship of the Ring was written by Fran Walsh
1546INSERT INTO MovieWriters (MovieID,WriterID) VALUES (66,52); # The Lord of the Rings: The Fellowship of the Ring was written by J.R.R. Tolkien
1547INSERT INTO MovieWriters (MovieID,WriterID) VALUES (67,103); # Joker was written by Scott Silver
1548INSERT INTO MovieWriters (MovieID,WriterID) VALUES (67,119); # Joker was written by Todd Phillips
1549INSERT INTO MovieWriters (MovieID,WriterID) VALUES (68,25); # Memento was written by Christopher Nolan
1550INSERT INTO MovieWriters (MovieID,WriterID) VALUES (68,60); # Memento was written by Jonathan Nolan
1551INSERT INTO MovieWriters (MovieID,WriterID) VALUES (69,25); # The Prestige was written by Christopher Nolan
1552INSERT INTO MovieWriters (MovieID,WriterID) VALUES (69,60); # The Prestige was written by Jonathan Nolan
1553INSERT INTO MovieWriters (MovieID,WriterID) VALUES (70,74); # Your Name. was written by Makoto Shinkai
1554INSERT INTO MovieWriters (MovieID,WriterID) VALUES (71,4); # American Beauty was written by Alan Ball
1555INSERT INTO MovieWriters (MovieID,WriterID) VALUES (72,35); # The Lives of Others was written by Florian Henckel von Donnersmarck
1556INSERT INTO MovieWriters (MovieID,WriterID) VALUES (73,76); # Saving Private Ryan was written by Matt Damon
1557INSERT INTO MovieWriters (MovieID,WriterID) VALUES (73,96); # Saving Private Ryan was written by Robert Rodat
1558INSERT INTO MovieWriters (MovieID,WriterID) VALUES (74,42); # Raiders of the Lost Ark was written by George Lucas
1559INSERT INTO MovieWriters (MovieID,WriterID) VALUES (74,66); # Raiders of the Lost Ark was written by Lawrence Kasdan
1560INSERT INTO MovieWriters (MovieID,WriterID) VALUES (75,104); # Once Upon a Time in the West was written by Sergio Donati
1561INSERT INTO MovieWriters (MovieID,WriterID) VALUES (75,105); # Once Upon a Time in the West was written by Sergio Leone
1562INSERT INTO MovieWriters (MovieID,WriterID) VALUES (76,38); # The Godfather was written by Francis Ford Coppola
1563INSERT INTO MovieWriters (MovieID,WriterID) VALUES (76,75); # The Godfather was written by Mario Puzo
1564INSERT INTO MovieWriters (MovieID,WriterID) VALUES (77,53); # Terminator 2: Judgment Day was written by James Cameron
1565INSERT INTO MovieWriters (MovieID,WriterID) VALUES (77,122); # Terminator 2: Judgment Day was written by William Wisher
1566INSERT INTO MovieWriters (MovieID,WriterID) VALUES (78,50); # The Lion King was written by Irene Mecchi
1567INSERT INTO MovieWriters (MovieID,WriterID) VALUES (78,61); # The Lion King was written by Jonathan Roberts
1568INSERT INTO MovieWriters (MovieID,WriterID) VALUES (79,42); # Star Wars: Episode VI - Return of the Jedi was written by George Lucas
1569INSERT INTO MovieWriters (MovieID,WriterID) VALUES (79,66); # Star Wars: Episode VI - Return of the Jedi was written by Lawrence Kasdan
1570INSERT INTO MovieWriters (MovieID,WriterID) VALUES (80,9); # Seven was written by Andrew Kevin Walker
1571INSERT INTO MovieWriters (MovieID,WriterID) VALUES (81,14); # Sunset Blvd. was written by Billy Wilder
1572INSERT INTO MovieWriters (MovieID,WriterID) VALUES (81,20); # Sunset Blvd. was written by Charles Brackett
1573INSERT INTO MovieWriters (MovieID,WriterID) VALUES (82,47); # Spirited Away was written by Hayao Miyazaki
1574INSERT INTO MovieWriters (MovieID,WriterID) VALUES (83,91); # Pulp Fiction was written by Quentin Tarantino
1575INSERT INTO MovieWriters (MovieID,WriterID) VALUES (83,100); # Pulp Fiction was written by Roger Avary
1576INSERT INTO MovieWriters (MovieID,WriterID) VALUES (84,45); # Snatch was written by Guy Ritchie
1577INSERT INTO MovieWriters (MovieID,WriterID) VALUES (85,26); # Fight Club was written by Chuck Palahniuk
1578INSERT INTO MovieWriters (MovieID,WriterID) VALUES (85,56); # Fight Club was written by Jim Uhls
1579INSERT INTO MovieWriters (MovieID,WriterID) VALUES (86,62); # Psycho was written by Joseph Stefano
1580INSERT INTO MovieWriters (MovieID,WriterID) VALUES (86,95); # Psycho was written by Robert Bloch
1581INSERT INTO MovieWriters (MovieID,WriterID) VALUES (87,48); # Citizen Kane was written by Herman J. Mankiewicz
1582INSERT INTO MovieWriters (MovieID,WriterID) VALUES (87,83); # Citizen Kane was written by Orson Welles
1583INSERT INTO MovieWriters (MovieID,WriterID) VALUES (88,71); # Das Boot was written by Lothar G. Buchheim
1584INSERT INTO MovieWriters (MovieID,WriterID) VALUES (88,125); # Das Boot was written by Wolfgang Petersen
1585INSERT INTO MovieWriters (MovieID,WriterID) VALUES (89,19); # Paths of Glory was written by Calder Willingham
1586INSERT INTO MovieWriters (MovieID,WriterID) VALUES (89,108); # Paths of Glory was written by Stanley Kubrick
1587INSERT INTO MovieWriters (MovieID,WriterID) VALUES (90,87); # Spider-Man: Into the Spider-Verse was written by Phil Lord
1588INSERT INTO MovieWriters (MovieID,WriterID) VALUES (90,99); # Spider-Man: Into the Spider-Verse was written by Rodney Rothman
1589INSERT INTO MovieWriters (MovieID,WriterID) VALUES (91,86); # Amadeus was written by Peter Shaffer
1590INSERT INTO MovieWriters (MovieID,WriterID) VALUES (92,91); # Django Unchained was written by Quentin Tarantino
1591INSERT INTO MovieWriters (MovieID,WriterID) VALUES (93,73); # The Good, the Bad and the Ugly was written by Luciano Vincenzoni
1592INSERT INTO MovieWriters (MovieID,WriterID) VALUES (93,105); # The Good, the Bad and the Ugly was written by Sergio Leone
1593INSERT INTO MovieWriters (MovieID,WriterID) VALUES (94,80); # Goodfellas was written by Nicholas Pileggi
1594INSERT INTO MovieWriters (MovieID,WriterID) VALUES (95,28); # Whiplash was written by Damien Chazelle
1595INSERT INTO MovieWriters (MovieID,WriterID) VALUES (96,38); # The Godfather: Part II was written by Francis Ford Coppola
1596INSERT INTO MovieWriters (MovieID,WriterID) VALUES (96,75); # The Godfather: Part II was written by Mario Puzo
1597INSERT INTO MovieWriters (MovieID,WriterID) VALUES (97,17); # Parasite was written by Bong Joon Ho
1598INSERT INTO MovieWriters (MovieID,WriterID) VALUES (98,108); # Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb was written by Stanley Kubrick
1599INSERT INTO MovieWriters (MovieID,WriterID) VALUES (98,113); # Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb was written by Terry Southern
1600INSERT INTO MovieWriters (MovieID,WriterID) VALUES (99,43); # Cinema Paradiso was written by Giuseppe Tornatore
1601INSERT INTO MovieWriters (MovieID,WriterID) VALUES (100,25); # The Dark Knight Rises was written by Christopher Nolan
1602INSERT INTO MovieWriters (MovieID,WriterID) VALUES (100,60); # The Dark Knight Rises was written by Jonathan Nolan
1603
1604SELECT * FROM MovieWriters ORDER BY MovieID ASC;
1605
1606#################################################################################### INSERT MovieCast
1607
1608INSERT INTO MovieCast (MovieID,CastID) VALUES (1,30); # Carrie Henn is in Aliens
1609INSERT INTO MovieCast (MovieID,CastID) VALUES (1,167); # Michael Biehn is in Aliens
1610INSERT INTO MovieCast (MovieID,CastID) VALUES (1,211); # Sigourney Weaver is in Aliens
1611INSERT INTO MovieCast (MovieID,CastID) VALUES (2,97); # Jack Nicholson is in One Flew Over the Cuckoo\'s Nest
1612INSERT INTO MovieCast (MovieID,CastID) VALUES (2,146); # Louise Fletcher is in One Flew Over the Cuckoo\'s Nest
1613INSERT INTO MovieCast (MovieID,CastID) VALUES (2,241); # Will Sampson is in One Flew Over the Cuckoo\'s Nest
1614INSERT INTO MovieCast (MovieID,CastID) VALUES (3,34); # Charles Chaplin is in The Kid
1615INSERT INTO MovieCast (MovieID,CastID) VALUES (3,53); # Edna Purviance is in The Kid
1616INSERT INTO MovieCast (MovieID,CastID) VALUES (3,99); # Jackie Coogan is in The Kid
1617INSERT INTO MovieCast (MovieID,CastID) VALUES (4,79); # Giorgio Cantarini is in Life Is Beautiful
1618INSERT INTO MovieCast (MovieID,CastID) VALUES (4,178); # Nicoletta Braschi is in Life Is Beautiful
1619INSERT INTO MovieCast (MovieID,CastID) VALUES (4,197); # Roberto Benigni is in Life Is Beautiful
1620INSERT INTO MovieCast (MovieID,CastID) VALUES (5,245); # Yuriko Ishida is in Princess Mononoke
1621INSERT INTO MovieCast (MovieID,CastID) VALUES (5,246); # Yôji Matsuda is in Princess Mononoke
1622INSERT INTO MovieCast (MovieID,CastID) VALUES (5,247); # Yûko Tanaka is in Princess Mononoke
1623INSERT INTO MovieCast (MovieID,CastID) VALUES (6,35); # Charles Laughton is in Witness for the Prosecution
1624INSERT INTO MovieCast (MovieID,CastID) VALUES (6,152); # Marlene Dietrich is in Witness for the Prosecution
1625INSERT INTO MovieCast (MovieID,CastID) VALUES (6,233); # Tyrone Power is in Witness for the Prosecution
1626INSERT INTO MovieCast (MovieID,CastID) VALUES (7,36); # Chazz Palminteri is in The Usual Suspects
1627INSERT INTO MovieCast (MovieID,CastID) VALUES (7,73); # Gabriel Byrne is in The Usual Suspects
1628INSERT INTO MovieCast (MovieID,CastID) VALUES (7,132); # Kevin Spacey is in The Usual Suspects
1629INSERT INTO MovieCast (MovieID,CastID) VALUES (8,4); # Adrien Brody is in The Pianist
1630INSERT INTO MovieCast (MovieID,CastID) VALUES (8,71); # Frank Finlay is in The Pianist
1631INSERT INTO MovieCast (MovieID,CastID) VALUES (8,219); # Thomas Kretschmann is in The Pianist
1632INSERT INTO MovieCast (MovieID,CastID) VALUES (9,38); # Chris Hemsworth is in Avengers: Infinity War
1633INSERT INTO MovieCast (MovieID,CastID) VALUES (9,151); # Mark Ruffalo is in Avengers: Infinity War
1634INSERT INTO MovieCast (MovieID,CastID) VALUES (9,195); # Robert Downey Jr. is in Avengers: Infinity War
1635INSERT INTO MovieCast (MovieID,CastID) VALUES (10,58); # Elijah Wood is in The Lord of the Rings: The Return of the King
1636INSERT INTO MovieCast (MovieID,CastID) VALUES (10,93); # Ian McKellen is in The Lord of the Rings: The Return of the King
1637INSERT INTO MovieCast (MovieID,CastID) VALUES (10,237); # Viggo Mortensen is in The Lord of the Rings: The Return of the King
1638INSERT INTO MovieCast (MovieID,CastID) VALUES (11,18); # Audrey Tautou is in Amélie
1639INSERT INTO MovieCast (MovieID,CastID) VALUES (11,158); # Mathieu Kassovitz is in Amélie
1640INSERT INTO MovieCast (MovieID,CastID) VALUES (11,200); # Rufus is in Amélie
1641INSERT INTO MovieCast (MovieID,CastID) VALUES (12,31); # Carrie-Anne Moss is in The Matrix
1642INSERT INTO MovieCast (MovieID,CastID) VALUES (12,129); # Keanu Reeves is in The Matrix
1643INSERT INTO MovieCast (MovieID,CastID) VALUES (12,136); # Laurence Fishburne is in The Matrix
1644INSERT INTO MovieCast (MovieID,CastID) VALUES (13,75); # Gary Lockwood is in 2001: A Space Odyssey
1645INSERT INTO MovieCast (MovieID,CastID) VALUES (13,131); # Keir Dullea is in 2001: A Space Odyssey
1646INSERT INTO MovieCast (MovieID,CastID) VALUES (13,243); # William Sylvester is in 2001: A Space Odyssey
1647INSERT INTO MovieCast (MovieID,CastID) VALUES (14,58); # Elijah Wood is in The Lord of the Rings: The Two Towers
1648INSERT INTO MovieCast (MovieID,CastID) VALUES (14,93); # Ian McKellen is in The Lord of the Rings: The Two Towers
1649INSERT INTO MovieCast (MovieID,CastID) VALUES (14,237); # Viggo Mortensen is in The Lord of the Rings: The Two Towers
1650INSERT INTO MovieCast (MovieID,CastID) VALUES (15,29); # Carrie Fisher is in Star Wars: Episode V - The Empire Strikes Back
1651INSERT INTO MovieCast (MovieID,CastID) VALUES (15,84); # Harrison Ford is in Star Wars: Episode V - The Empire Strikes Back
1652INSERT INTO MovieCast (MovieID,CastID) VALUES (15,150); # Mark Hamill is in Star Wars: Episode V - The Empire Strikes Back
1653INSERT INTO MovieCast (MovieID,CastID) VALUES (16,153); # Marlon Brando is in Apocalypse Now
1654INSERT INTO MovieCast (MovieID,CastID) VALUES (16,155); # Martin Sheen is in Apocalypse Now
1655INSERT INTO MovieCast (MovieID,CastID) VALUES (16,196); # Robert Duvall is in Apocalypse Now
1656INSERT INTO MovieCast (MovieID,CastID) VALUES (17,32); # Cary Grant is in North by Northwest
1657INSERT INTO MovieCast (MovieID,CastID) VALUES (17,67); # Eva Marie Saint is in North by Northwest
1658INSERT INTO MovieCast (MovieID,CastID) VALUES (17,103); # James Mason is in North by Northwest
1659INSERT INTO MovieCast (MovieID,CastID) VALUES (18,45); # Danny Lloyd is in The Shining
1660INSERT INTO MovieCast (MovieID,CastID) VALUES (18,97); # Jack Nicholson is in The Shining
1661INSERT INTO MovieCast (MovieID,CastID) VALUES (18,209); # Shelley Duvall is in The Shining
1662INSERT INTO MovieCast (MovieID,CastID) VALUES (19,1); # Aamir Khan is in 3 Idiots
1663INSERT INTO MovieCast (MovieID,CastID) VALUES (19,147); # Madhavan is in 3 Idiots
1664INSERT INTO MovieCast (MovieID,CastID) VALUES (19,174); # Mona Singh is in 3 Idiots
1665INSERT INTO MovieCast (MovieID,CastID) VALUES (20,37); # Chris Evans is in Avengers: Endgame
1666INSERT INTO MovieCast (MovieID,CastID) VALUES (20,151); # Mark Ruffalo is in Avengers: Endgame
1667INSERT INTO MovieCast (MovieID,CastID) VALUES (20,195); # Robert Downey Jr. is in Avengers: Endgame
1668INSERT INTO MovieCast (MovieID,CastID) VALUES (21,61); # Elizabeth McGovern is in Once Upon a Time in America
1669INSERT INTO MovieCast (MovieID,CastID) VALUES (21,105); # James Woods is in Once Upon a Time in America
1670INSERT INTO MovieCast (MovieID,CastID) VALUES (21,194); # Robert De Niro is in Once Upon a Time in America
1671INSERT INTO MovieCast (MovieID,CastID) VALUES (22,2); # Aaron Eckhart is in The Dark Knight
1672INSERT INTO MovieCast (MovieID,CastID) VALUES (22,39); # Christian Bale is in The Dark Knight
1673INSERT INTO MovieCast (MovieID,CastID) VALUES (22,86); # Heath Ledger is in The Dark Knight
1674INSERT INTO MovieCast (MovieID,CastID) VALUES (23,10); # Anne Le Ny is in Untouchable
1675INSERT INTO MovieCast (MovieID,CastID) VALUES (23,72); # François Cluzet is in Untouchable
1676INSERT INTO MovieCast (MovieID,CastID) VALUES (23,179); # Omar Sy is in Untouchable
1677INSERT INTO MovieCast (MovieID,CastID) VALUES (24,91); # Humphrey Bogart is in Casablanca
1678INSERT INTO MovieCast (MovieID,CastID) VALUES (24,95); # Ingrid Bergman is in Casablanca
1679INSERT INTO MovieCast (MovieID,CastID) VALUES (24,185); # Paul Henreid is in Casablanca
1680INSERT INTO MovieCast (MovieID,CastID) VALUES (25,20); # Barbara Bel Geddes is in Vertigo
1681INSERT INTO MovieCast (MovieID,CastID) VALUES (25,104); # James Stewart is in Vertigo
1682INSERT INTO MovieCast (MovieID,CastID) VALUES (25,133); # Kim Novak is in Vertigo
1683INSERT INTO MovieCast (MovieID,CastID) VALUES (26,9); # Anne Hathaway is in Interstellar
1684INSERT INTO MovieCast (MovieID,CastID) VALUES (26,114); # Jessica Chastain is in Interstellar
1685INSERT INTO MovieCast (MovieID,CastID) VALUES (26,161); # Matthew McConaughey is in Interstellar
1686INSERT INTO MovieCast (MovieID,CastID) VALUES (27,6); # Akira Ishihama is in Harakiri
1687INSERT INTO MovieCast (MovieID,CastID) VALUES (27,210); # Shima Iwashita is in Harakiri
1688INSERT INTO MovieCast (MovieID,CastID) VALUES (27,217); # Tatsuya Nakadai is in Harakiri
1689INSERT INTO MovieCast (MovieID,CastID) VALUES (28,29); # Carrie Fisher is in Star Wars: Episode IV - A New Hope
1690INSERT INTO MovieCast (MovieID,CastID) VALUES (28,84); # Harrison Ford is in Star Wars: Episode IV - A New Hope
1691INSERT INTO MovieCast (MovieID,CastID) VALUES (28,150); # Mark Hamill is in Star Wars: Episode IV - A New Hope
1692INSERT INTO MovieCast (MovieID,CastID) VALUES (29,21); # Ben Affleck is in Good Will Hunting
1693INSERT INTO MovieCast (MovieID,CastID) VALUES (29,159); # Matt Damon is in Good Will Hunting
1694INSERT INTO MovieCast (MovieID,CastID) VALUES (29,198); # Robin Williams is in Good Will Hunting
1695INSERT INTO MovieCast (MovieID,CastID) VALUES (30,1); # Aamir Khan is in Dangal
1696INSERT INTO MovieCast (MovieID,CastID) VALUES (30,69); # Fatima Sana Shaikh is in Dangal
1697INSERT INTO MovieCast (MovieID,CastID) VALUES (30,204); # Sakshi Tanwar is in Dangal
1698INSERT INTO MovieCast (MovieID,CastID) VALUES (31,149); # Malcolm McDowell is in A Clockwork Orange
1699INSERT INTO MovieCast (MovieID,CastID) VALUES (31,166); # Michael Bates is in A Clockwork Orange
1700INSERT INTO MovieCast (MovieID,CastID) VALUES (31,182); # Patrick Magee is in A Clockwork Orange
1701INSERT INTO MovieCast (MovieID,CastID) VALUES (32,116); # Jim Carrey is in Eternal Sunshine of the Spotless Mind
1702INSERT INTO MovieCast (MovieID,CastID) VALUES (32,128); # Kate Winslet is in Eternal Sunshine of the Spotless Mind
1703INSERT INTO MovieCast (MovieID,CastID) VALUES (32,230); # Tom Wilkinson is in Eternal Sunshine of the Spotless Mind
1704INSERT INTO MovieCast (MovieID,CastID) VALUES (33,13); # Anthony Gonzalez is in Coco
1705INSERT INTO MovieCast (MovieID,CastID) VALUES (33,25); # Benjamin Bratt is in Coco
1706INSERT INTO MovieCast (MovieID,CastID) VALUES (33,74); # Gael García Bernal is in Coco
1707INSERT INTO MovieCast (MovieID,CastID) VALUES (34,1); # Aamir Khan is in Like Stars on Earth
1708INSERT INTO MovieCast (MovieID,CastID) VALUES (34,46); # Darsheel Safary is in Like Stars on Earth
1709INSERT INTO MovieCast (MovieID,CastID) VALUES (34,224); # Tisca Chopra is in Like Stars on Earth
1710INSERT INTO MovieCast (MovieID,CastID) VALUES (35,88); # Henry Fonda is in 12 Angry Men
1711INSERT INTO MovieCast (MovieID,CastID) VALUES (35,140); # Lee J. Cobb is in 12 Angry Men
1712INSERT INTO MovieCast (MovieID,CastID) VALUES (35,154); # Martin Balsam is in 12 Angry Men
1713INSERT INTO MovieCast (MovieID,CastID) VALUES (36,97); # Jack Nicholson is in The Departed
1714INSERT INTO MovieCast (MovieID,CastID) VALUES (36,142); # Leonardo DiCaprio is in The Departed
1715INSERT INTO MovieCast (MovieID,CastID) VALUES (36,159); # Matt Damon is in The Departed
1716INSERT INTO MovieCast (MovieID,CastID) VALUES (37,63); # Ellen Page is in Inception
1717INSERT INTO MovieCast (MovieID,CastID) VALUES (37,124); # Joseph Gordon-Levitt is in Inception
1718INSERT INTO MovieCast (MovieID,CastID) VALUES (37,142); # Leonardo DiCaprio is in Inception
1719INSERT INTO MovieCast (MovieID,CastID) VALUES (38,12); # Annika Wedderkopp is in The Hunt
1720INSERT INTO MovieCast (MovieID,CastID) VALUES (38,148); # Mads Mikkelsen is in The Hunt
1721INSERT INTO MovieCast (MovieID,CastID) VALUES (38,218); # Thomas Bo Larsen is in The Hunt
1722INSERT INTO MovieCast (MovieID,CastID) VALUES (39,62); # Ellen Burstyn is in Requiem for a Dream
1723INSERT INTO MovieCast (MovieID,CastID) VALUES (39,108); # Jared Leto is in Requiem for a Dream
1724INSERT INTO MovieCast (MovieID,CastID) VALUES (39,112); # Jennifer Connelly is in Requiem for a Dream
1725INSERT INTO MovieCast (MovieID,CastID) VALUES (40,22); # Ben Burtt is in WALL·E
1726INSERT INTO MovieCast (MovieID,CastID) VALUES (40,59); # Elissa Knight is in WALL·E
1727INSERT INTO MovieCast (MovieID,CastID) VALUES (40,111); # Jeff Garlin is in WALL·E
1728INSERT INTO MovieCast (MovieID,CastID) VALUES (41,51); # Donna Reed is in It\'s a Wonderful Life
1729INSERT INTO MovieCast (MovieID,CastID) VALUES (41,104); # James Stewart is in It\'s a Wonderful Life
1730INSERT INTO MovieCast (MovieID,CastID) VALUES (41,145); # Lionel Barrymore is in It\'s a Wonderful Life
1731INSERT INTO MovieCast (MovieID,CastID) VALUES (42,121); # John Hurt is in Alien
1732INSERT INTO MovieCast (MovieID,CastID) VALUES (42,211); # Sigourney Weaver is in Alien
1733INSERT INTO MovieCast (MovieID,CastID) VALUES (42,229); # Tom Skerritt is in Alien
1734INSERT INTO MovieCast (MovieID,CastID) VALUES (43,26); # Beverly D\'Angelo is in American History X
1735INSERT INTO MovieCast (MovieID,CastID) VALUES (43,54); # Edward Furlong is in American History X
1736INSERT INTO MovieCast (MovieID,CastID) VALUES (43,55); # Edward Norton is in American History X
1737INSERT INTO MovieCast (MovieID,CastID) VALUES (44,50); # Don Rickles is in Toy Story
1738INSERT INTO MovieCast (MovieID,CastID) VALUES (44,221); # Tim Allen is in Toy Story
1739INSERT INTO MovieCast (MovieID,CastID) VALUES (44,225); # Tom Hanks is in Toy Story
1740INSERT INTO MovieCast (MovieID,CastID) VALUES (45,130); # Keiko Tsushima is in Seven Samurai
1741INSERT INTO MovieCast (MovieID,CastID) VALUES (45,216); # Takashi Shimura is in Seven Samurai
1742INSERT INTO MovieCast (MovieID,CastID) VALUES (45,231); # Toshirô Mifune is in Seven Samurai
1743INSERT INTO MovieCast (MovieID,CastID) VALUES (46,34); # Charles Chaplin is in Modern Times
1744INSERT INTO MovieCast (MovieID,CastID) VALUES (46,87); # Henry Bergman is in Modern Times
1745INSERT INTO MovieCast (MovieID,CastID) VALUES (46,186); # Paulette Goddard is in Modern Times
1746INSERT INTO MovieCast (MovieID,CastID) VALUES (47,48); # David Morse is in The Green Mile
1747INSERT INTO MovieCast (MovieID,CastID) VALUES (47,168); # Michael Clarke Duncan is in The Green Mile
1748INSERT INTO MovieCast (MovieID,CastID) VALUES (47,225); # Tom Hanks is in The Green Mile
1749INSERT INTO MovieCast (MovieID,CastID) VALUES (48,23); # Ben Kingsley is in Schindler\'s List
1750INSERT INTO MovieCast (MovieID,CastID) VALUES (48,143); # Liam Neeson is in Schindler\'s List
1751INSERT INTO MovieCast (MovieID,CastID) VALUES (48,191); # Ralph Fiennes is in Schindler\'s List
1752INSERT INTO MovieCast (MovieID,CastID) VALUES (49,81); # Grace Kelly is in Rear Window
1753INSERT INTO MovieCast (MovieID,CastID) VALUES (49,104); # James Stewart is in Rear Window
1754INSERT INTO MovieCast (MovieID,CastID) VALUES (49,240); # Wendell Corey is in Rear Window
1755INSERT INTO MovieCast (MovieID,CastID) VALUES (50,162); # Matthew Modine is in Full Metal Jacket
1756INSERT INTO MovieCast (MovieID,CastID) VALUES (50,190); # R. Lee Ermey is in Full Metal Jacket
1757INSERT INTO MovieCast (MovieID,CastID) VALUES (50,238); # Vincent D\'Onofrio is in Full Metal Jacket
1758INSERT INTO MovieCast (MovieID,CastID) VALUES (51,34); # Charles Chaplin is in City Lights
1759INSERT INTO MovieCast (MovieID,CastID) VALUES (51,70); # Florence Lee is in City Lights
1760INSERT INTO MovieCast (MovieID,CastID) VALUES (51,239); # Virginia Cherrill is in City Lights
1761INSERT INTO MovieCast (MovieID,CastID) VALUES (52,34); # Charles Chaplin is in The Great Dictator
1762INSERT INTO MovieCast (MovieID,CastID) VALUES (52,98); # Jack Oakie is in The Great Dictator
1763INSERT INTO MovieCast (MovieID,CastID) VALUES (52,186); # Paulette Goddard is in The Great Dictator
1764INSERT INTO MovieCast (MovieID,CastID) VALUES (53,64); # Ellen Widmann is in M
1765INSERT INTO MovieCast (MovieID,CastID) VALUES (53,94); # Inge Landgut is in M
1766INSERT INTO MovieCast (MovieID,CastID) VALUES (53,187); # Peter Lorre is in M
1767INSERT INTO MovieCast (MovieID,CastID) VALUES (54,5); # Akemi Yamaguchi is in Grave of the Fireflies
1768INSERT INTO MovieCast (MovieID,CastID) VALUES (54,19); # Ayano Shiraishi is in Grave of the Fireflies
1769INSERT INTO MovieCast (MovieID,CastID) VALUES (54,232); # Tsutomu Tatsumi is in Grave of the Fireflies
1770INSERT INTO MovieCast (MovieID,CastID) VALUES (55,14); # Anthony Hopkins is in The Silence of the Lambs
1771INSERT INTO MovieCast (MovieID,CastID) VALUES (55,118); # Jodie Foster is in The Silence of the Lambs
1772INSERT INTO MovieCast (MovieID,CastID) VALUES (55,137); # Lawrence A. Bonney is in The Silence of the Lambs
1773INSERT INTO MovieCast (MovieID,CastID) VALUES (56,44); # Connie Nielsen is in Gladiator
1774INSERT INTO MovieCast (MovieID,CastID) VALUES (56,117); # Joaquin Phoenix is in Gladiator
1775INSERT INTO MovieCast (MovieID,CastID) VALUES (56,201); # Russell Crowe is in Gladiator
1776INSERT INTO MovieCast (MovieID,CastID) VALUES (57,41); # Christopher Lloyd is in Back to the Future
1777INSERT INTO MovieCast (MovieID,CastID) VALUES (57,138); # Lea Thompson is in Back to the Future
1778INSERT INTO MovieCast (MovieID,CastID) VALUES (57,169); # Michael J. Fox is in Back to the Future
1779INSERT INTO MovieCast (MovieID,CastID) VALUES (58,164); # Mel Gibson is in Braveheart
1780INSERT INTO MovieCast (MovieID,CastID) VALUES (58,183); # Patrick McGoohan is in Braveheart
1781INSERT INTO MovieCast (MovieID,CastID) VALUES (58,212); # Sophie Marceau is in Braveheart
1782INSERT INTO MovieCast (MovieID,CastID) VALUES (59,76); # Gary Oldman is in Leon
1783INSERT INTO MovieCast (MovieID,CastID) VALUES (59,110); # Jean Reno is in Leon
1784INSERT INTO MovieCast (MovieID,CastID) VALUES (59,177); # Natalie Portman is in Leon
1785INSERT INTO MovieCast (MovieID,CastID) VALUES (60,28); # Brad Pitt is in Inglourious Basterds
1786INSERT INTO MovieCast (MovieID,CastID) VALUES (60,49); # Diane Kruger is in Inglourious Basterds
1787INSERT INTO MovieCast (MovieID,CastID) VALUES (60,56); # Eli Roth is in Inglourious Basterds
1788INSERT INTO MovieCast (MovieID,CastID) VALUES (61,27); # Bob Gunton is in The Shawshank Redemption
1789INSERT INTO MovieCast (MovieID,CastID) VALUES (61,176); # Morgan Freeman is in The Shawshank Redemption
1790INSERT INTO MovieCast (MovieID,CastID) VALUES (61,222); # Tim Robbins is in The Shawshank Redemption
1791INSERT INTO MovieCast (MovieID,CastID) VALUES (62,92); # Hye-jeong Kang is in Oldboy
1792INSERT INTO MovieCast (MovieID,CastID) VALUES (62,115); # Ji-Tae Yoo is in Oldboy
1793INSERT INTO MovieCast (MovieID,CastID) VALUES (62,172); # Min-sik Choi is in Oldboy
1794INSERT INTO MovieCast (MovieID,CastID) VALUES (63,8); # Alexandre Rodrigues is in City of God
1795INSERT INTO MovieCast (MovieID,CastID) VALUES (63,139); # Leandro Firmino is in City of God
1796INSERT INTO MovieCast (MovieID,CastID) VALUES (63,157); # Matheus Nachtergaele is in City of God
1797INSERT INTO MovieCast (MovieID,CastID) VALUES (64,77); # Gary Sinise is in Forrest Gump
1798INSERT INTO MovieCast (MovieID,CastID) VALUES (64,199); # Robin Wright is in Forrest Gump
1799INSERT INTO MovieCast (MovieID,CastID) VALUES (64,225); # Tom Hanks is in Forrest Gump
1800INSERT INTO MovieCast (MovieID,CastID) VALUES (65,85); # Harvey Keitel is in Reservoir Dogs
1801INSERT INTO MovieCast (MovieID,CastID) VALUES (65,170); # Michael Madsen is in Reservoir Dogs
1802INSERT INTO MovieCast (MovieID,CastID) VALUES (65,223); # Tim Roth is in Reservoir Dogs
1803INSERT INTO MovieCast (MovieID,CastID) VALUES (66,58); # Elijah Wood is in The Lord of the Rings: The Fellowship of the Ring
1804INSERT INTO MovieCast (MovieID,CastID) VALUES (66,93); # Ian McKellen is in The Lord of the Rings: The Fellowship of the Ring
1805INSERT INTO MovieCast (MovieID,CastID) VALUES (66,180); # Orlando Bloom is in The Lord of the Rings: The Fellowship of the Ring
1806INSERT INTO MovieCast (MovieID,CastID) VALUES (67,117); # Joaquin Phoenix is in Joker
1807INSERT INTO MovieCast (MovieID,CastID) VALUES (67,194); # Robert De Niro is in Joker
1808INSERT INTO MovieCast (MovieID,CastID) VALUES (67,248); # Zazie Beetz is in Joker
1809INSERT INTO MovieCast (MovieID,CastID) VALUES (68,31); # Carrie-Anne Moss is in Memento
1810INSERT INTO MovieCast (MovieID,CastID) VALUES (68,82); # Guy Pearce is in Memento
1811INSERT INTO MovieCast (MovieID,CastID) VALUES (68,119); # Joe Pantoliano is in Memento
1812INSERT INTO MovieCast (MovieID,CastID) VALUES (69,39); # Christian Bale is in The Prestige
1813INSERT INTO MovieCast (MovieID,CastID) VALUES (69,90); # Hugh Jackman is in The Prestige
1814INSERT INTO MovieCast (MovieID,CastID) VALUES (69,206); # Scarlett Johansson is in The Prestige
1815INSERT INTO MovieCast (MovieID,CastID) VALUES (70,175); # Mone Kamishiraishi is in Your Name.
1816INSERT INTO MovieCast (MovieID,CastID) VALUES (70,202); # Ryô Narita is in Your Name.
1817INSERT INTO MovieCast (MovieID,CastID) VALUES (70,203); # Ryûnosuke Kamiki is in Your Name.
1818INSERT INTO MovieCast (MovieID,CastID) VALUES (71,11); # Annette Bening is in American Beauty
1819INSERT INTO MovieCast (MovieID,CastID) VALUES (71,132); # Kevin Spacey is in American Beauty
1820INSERT INTO MovieCast (MovieID,CastID) VALUES (71,220); # Thora Birch is in American Beauty
1821INSERT INTO MovieCast (MovieID,CastID) VALUES (72,156); # Martina Gedeck is in The Lives of Others
1822INSERT INTO MovieCast (MovieID,CastID) VALUES (72,207); # Sebastian Koch is in The Lives of Others
1823INSERT INTO MovieCast (MovieID,CastID) VALUES (72,234); # Ulrich Mühe is in The Lives of Others
1824INSERT INTO MovieCast (MovieID,CastID) VALUES (73,159); # Matt Damon is in Saving Private Ryan
1825INSERT INTO MovieCast (MovieID,CastID) VALUES (73,225); # Tom Hanks is in Saving Private Ryan
1826INSERT INTO MovieCast (MovieID,CastID) VALUES (73,228); # Tom Sizemore is in Saving Private Ryan
1827INSERT INTO MovieCast (MovieID,CastID) VALUES (74,84); # Harrison Ford is in Raiders of the Lost Ark
1828INSERT INTO MovieCast (MovieID,CastID) VALUES (74,127); # Karen Allen is in Raiders of the Lost Ark
1829INSERT INTO MovieCast (MovieID,CastID) VALUES (74,184); # Paul Freeman is in Raiders of the Lost Ark
1830INSERT INTO MovieCast (MovieID,CastID) VALUES (75,33); # Charles Bronson is in Once Upon a Time in the West
1831INSERT INTO MovieCast (MovieID,CastID) VALUES (75,42); # Claudia Cardinale is in Once Upon a Time in the West
1832INSERT INTO MovieCast (MovieID,CastID) VALUES (75,88); # Henry Fonda is in Once Upon a Time in the West
1833INSERT INTO MovieCast (MovieID,CastID) VALUES (76,7); # Al Pacino is in The Godfather
1834INSERT INTO MovieCast (MovieID,CastID) VALUES (76,101); # James Caan is in The Godfather
1835INSERT INTO MovieCast (MovieID,CastID) VALUES (76,153); # Marlon Brando is in The Godfather
1836INSERT INTO MovieCast (MovieID,CastID) VALUES (77,17); # Arnold Schwarzenegger is in Terminator 2: Judgment Day
1837INSERT INTO MovieCast (MovieID,CastID) VALUES (77,54); # Edward Furlong is in Terminator 2: Judgment Day
1838INSERT INTO MovieCast (MovieID,CastID) VALUES (77,144); # Linda Hamilton is in Terminator 2: Judgment Day
1839INSERT INTO MovieCast (MovieID,CastID) VALUES (78,102); # James Earl Jones is in The Lion King
1840INSERT INTO MovieCast (MovieID,CastID) VALUES (78,113); # Jeremy Irons is in The Lion King
1841INSERT INTO MovieCast (MovieID,CastID) VALUES (78,160); # Matthew Broderick is in The Lion King
1842INSERT INTO MovieCast (MovieID,CastID) VALUES (79,29); # Carrie Fisher is in Star Wars: Episode VI - Return of the Jedi
1843INSERT INTO MovieCast (MovieID,CastID) VALUES (79,84); # Harrison Ford is in Star Wars: Episode VI - Return of the Jedi
1844INSERT INTO MovieCast (MovieID,CastID) VALUES (79,150); # Mark Hamill is in Star Wars: Episode VI - Return of the Jedi
1845INSERT INTO MovieCast (MovieID,CastID) VALUES (80,28); # Brad Pitt is in Seven
1846INSERT INTO MovieCast (MovieID,CastID) VALUES (80,132); # Kevin Spacey is in Seven
1847INSERT INTO MovieCast (MovieID,CastID) VALUES (80,176); # Morgan Freeman is in Seven
1848INSERT INTO MovieCast (MovieID,CastID) VALUES (81,66); # Erich von Stroheim is in Sunset Blvd.
1849INSERT INTO MovieCast (MovieID,CastID) VALUES (81,80); # Gloria Swanson is in Sunset Blvd.
1850INSERT INTO MovieCast (MovieID,CastID) VALUES (81,242); # William Holden is in Sunset Blvd.
1851INSERT INTO MovieCast (MovieID,CastID) VALUES (82,47); # Daveigh Chase is in Spirited Away
1852INSERT INTO MovieCast (MovieID,CastID) VALUES (82,173); # Miyu Irino is in Spirited Away
1853INSERT INTO MovieCast (MovieID,CastID) VALUES (82,215); # Suzanne Pleshette is in Spirited Away
1854INSERT INTO MovieCast (MovieID,CastID) VALUES (83,122); # John Travolta is in Pulp Fiction
1855INSERT INTO MovieCast (MovieID,CastID) VALUES (83,205); # Samuel L. Jackson is in Pulp Fiction
1856INSERT INTO MovieCast (MovieID,CastID) VALUES (83,235); # Uma Thurman is in Pulp Fiction
1857INSERT INTO MovieCast (MovieID,CastID) VALUES (84,24); # Benicio Del Toro is in Snatch
1858INSERT INTO MovieCast (MovieID,CastID) VALUES (84,28); # Brad Pitt is in Snatch
1859INSERT INTO MovieCast (MovieID,CastID) VALUES (84,109); # Jason Statham is in Snatch
1860INSERT INTO MovieCast (MovieID,CastID) VALUES (85,28); # Brad Pitt is in Fight Club
1861INSERT INTO MovieCast (MovieID,CastID) VALUES (85,55); # Edward Norton is in Fight Club
1862INSERT INTO MovieCast (MovieID,CastID) VALUES (85,163); # Meat Loaf is in Fight Club
1863INSERT INTO MovieCast (MovieID,CastID) VALUES (86,15); # Anthony Perkins is in Psycho
1864INSERT INTO MovieCast (MovieID,CastID) VALUES (86,107); # Janet Leigh is in Psycho
1865INSERT INTO MovieCast (MovieID,CastID) VALUES (86,236); # Vera Miles is in Psycho
1866INSERT INTO MovieCast (MovieID,CastID) VALUES (87,52); # Dorothy Comingore is in Citizen Kane
1867INSERT INTO MovieCast (MovieID,CastID) VALUES (87,123); # Joseph Cotten is in Citizen Kane
1868INSERT INTO MovieCast (MovieID,CastID) VALUES (87,181); # Orson Welles is in Citizen Kane
1869INSERT INTO MovieCast (MovieID,CastID) VALUES (88,89); # Herbert Grönemeyer is in Das Boot
1870INSERT INTO MovieCast (MovieID,CastID) VALUES (88,125); # Jürgen Prochnow is in Das Boot
1871INSERT INTO MovieCast (MovieID,CastID) VALUES (88,135); # Klaus Wennemann is in Das Boot
1872INSERT INTO MovieCast (MovieID,CastID) VALUES (89,3); # Adolphe Menjou is in Paths of Glory
1873INSERT INTO MovieCast (MovieID,CastID) VALUES (89,134); # Kirk Douglas is in Paths of Glory
1874INSERT INTO MovieCast (MovieID,CastID) VALUES (89,192); # Ralph Meeker is in Paths of Glory
1875INSERT INTO MovieCast (MovieID,CastID) VALUES (90,83); # Hailee Steinfeld is in Spider-Man: Into the Spider-Verse
1876INSERT INTO MovieCast (MovieID,CastID) VALUES (90,100); # Jake Johnson is in Spider-Man: Into the Spider-Verse
1877INSERT INTO MovieCast (MovieID,CastID) VALUES (90,208); # Shameik Moore is in Spider-Man: Into the Spider-Verse
1878INSERT INTO MovieCast (MovieID,CastID) VALUES (91,60); # Elizabeth Berridge is in Amadeus
1879INSERT INTO MovieCast (MovieID,CastID) VALUES (91,68); # F. Murray Abraham is in Amadeus
1880INSERT INTO MovieCast (MovieID,CastID) VALUES (91,227); # Tom Hulce is in Amadeus
1881INSERT INTO MovieCast (MovieID,CastID) VALUES (92,40); # Christoph Waltz is in Django Unchained
1882INSERT INTO MovieCast (MovieID,CastID) VALUES (92,106); # Jamie Foxx is in Django Unchained
1883INSERT INTO MovieCast (MovieID,CastID) VALUES (92,142); # Leonardo DiCaprio is in Django Unchained
1884INSERT INTO MovieCast (MovieID,CastID) VALUES (93,43); # Clint Eastwood is in The Good, the Bad and the Ugly
1885INSERT INTO MovieCast (MovieID,CastID) VALUES (93,57); # Eli Wallach is in The Good, the Bad and the Ugly
1886INSERT INTO MovieCast (MovieID,CastID) VALUES (93,141); # Lee Van Cleef is in The Good, the Bad and the Ugly
1887INSERT INTO MovieCast (MovieID,CastID) VALUES (94,120); # Joe Pesci is in Goodfellas
1888INSERT INTO MovieCast (MovieID,CastID) VALUES (94,193); # Ray Liotta is in Goodfellas
1889INSERT INTO MovieCast (MovieID,CastID) VALUES (94,194); # Robert De Niro is in Goodfellas
1890INSERT INTO MovieCast (MovieID,CastID) VALUES (95,96); # J.K. Simmons is in Whiplash
1891INSERT INTO MovieCast (MovieID,CastID) VALUES (95,165); # Melissa Benoist is in Whiplash
1892INSERT INTO MovieCast (MovieID,CastID) VALUES (95,171); # Miles Teller is in Whiplash
1893INSERT INTO MovieCast (MovieID,CastID) VALUES (96,7); # Al Pacino is in The Godfather: Part II
1894INSERT INTO MovieCast (MovieID,CastID) VALUES (96,194); # Robert De Niro is in The Godfather: Part II
1895INSERT INTO MovieCast (MovieID,CastID) VALUES (96,196); # Robert Duvall is in The Godfather: Part II
1896INSERT INTO MovieCast (MovieID,CastID) VALUES (97,126); # Kang-ho Song is in Parasite
1897INSERT INTO MovieCast (MovieID,CastID) VALUES (97,214); # Sun-kyun Lee is in Parasite
1898INSERT INTO MovieCast (MovieID,CastID) VALUES (97,244); # Yeo-jeong Jo is in Parasite
1899INSERT INTO MovieCast (MovieID,CastID) VALUES (98,78); # George C. Scott is in Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb
1900INSERT INTO MovieCast (MovieID,CastID) VALUES (98,188); # Peter Sellers is in Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb
1901INSERT INTO MovieCast (MovieID,CastID) VALUES (98,213); # Sterling Hayden is in Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb
1902INSERT INTO MovieCast (MovieID,CastID) VALUES (99,16); # Antonella Attili is in Cinema Paradiso
1903INSERT INTO MovieCast (MovieID,CastID) VALUES (99,65); # Enzo Cannavale is in Cinema Paradiso
1904INSERT INTO MovieCast (MovieID,CastID) VALUES (99,189); # Philippe Noiret is in Cinema Paradiso
1905INSERT INTO MovieCast (MovieID,CastID) VALUES (100,9); # Anne Hathaway is in The Dark Knight Rises
1906INSERT INTO MovieCast (MovieID,CastID) VALUES (100,39); # Christian Bale is in The Dark Knight Rises
1907INSERT INTO MovieCast (MovieID,CastID) VALUES (100,226); # Tom Hardy is in The Dark Knight Rises
1908
1909
1910select * from MovieCast order by MovieID asc;
1911
1912#################################################################################### insert Medias
1913
1914insert into Medias (Media) values ('DVD');
1915insert into Medias (Media) values ('BLU-RAY');
1916
1917select * from Medias;
1918
1919#################################################################################### insert Rentals
1920
1921insert into Rentals (CustomerID, MediaID, RentedOn, Returned, Held)
1922values (3, 1, '2020-3-15', false, true); #1
1923
1924insert into Rentals (CustomerID, MediaID, RentedOn, Returned, Held)
1925values (4, 1, '2020-3-15', false, true); #1
1926
1927insert into Rentals (CustomerID, MediaID, RentedOn, Returned, Held)
1928values (2, 1, '2020-3-15', false, true); #1
1929
1930insert into Rentals (CustomerID, MediaID, RentedOn, Returned, Held)
1931values (1, 1, '2020-3-15', false, true); #1
1932
1933insert into Rentals (CustomerID, MediaID, RentedOn, ReturnedOn, Returned, TotalDays, TotalCost)
1934values (5, 2, '2020-3-15', '2020-3-20', true, 5, 15.0); #2
1935
1936select * from Rentals;
1937SELECT * FROM Rentals ORDER BY ID DESC LIMIT 1;
1938UPDATE Rentals SET Returned = true WHERE ID = 9;
1939
1940#################################################################################### insert MovieRental
1941
1942insert into MovieRental (MovieID, RentalID) values (1, 1);
1943insert into MovieRental (MovieID, RentalID) values (3, 2);
1944insert into MovieRental (MovieID, RentalID) values (3, 3);
1945insert into MovieRental (MovieID, RentalID) values (4, 4);
1946insert into MovieRental (MovieID, RentalID) values (6, 5);
1947
1948select * from MovieRental order by MovieID asc;