b7GptUJQ

1
2DROP TABLE IF EXISTS movies;
3DROP TABLE IF EXISTS boxoffice;
4
5CREATE TABLE movies
6(
7	Id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
8	Title VARCHAR(255),
9	Director VARCHAR(255),
10	Year INT,
11	Length_min INT
12);
13
14CREATE TABLE boxoffice
15(
16	Rating DOUBLE,
17    Domestic_sales BIGINT,
18    International_sales BIGINT,
19    Aspect_ratio DOUBLE,
20    Language VARCHAR(50),
21    Movie_id INT NOT NULL,
22    Id INT PRIMARY KEY NOT NULL AUTO_INCREMENT
23);
24
25INSERT INTO movies
26	(Id, Title,	Director, Year,	Length_min)
27VALUES
28	(1,	'Toy Story',	'John Lasseter',	1995,	81),
29	(3,	'Toy Story 2',	'John Lasseter',	2000,	93),
30	(6,	'The Incredibles',	'Brad Bird',	2004,	116),
31	(11,	'Toy Story 3',	'Lee Unkrich',	2010,	103);
32    
33INSERT INTO boxoffice
34	(Rating, Domestic_sales, International_sales, Aspect_ratio, Language, Movie_id)
35VALUES
36	(7.9,	245852179,	239163000,	1.85,	'English',	3),
37	(8,		261441092,	370001000,	2.35,	'French',	6),
38	(8.4,	415004880,	648167031,	1.85,	'English',	11),
39	(8.3,	191796233,	170162503,	1.85,	'English',	1);