CREATE TABLE Movie (
   ID INT UNSIGNED PRIMARY KEY, 
   Title VARCHAR(30), 
   Genre VARCHAR(20), 
   RatingCode VARCHAR(5), 
   Year INT UNSIGNED
); 

CREATE TABLE YearStats ( 
    Year INT UNSIGNED PRIMARY KEY, 
    TotalGross BIGINT UNSIGNED, 
    Releases INT UNSIGNED
    );

INSERT INTO Movie (ID, Title, Genre, RatingCode, Year)
VALUES
(11, 'Inception', 'Sci-Fi', 'PG-13', 2010),
(12, 'The Godfather', 'Crime', 'R', 1972),
(13, 'Forrest Gump', 'Drama', 'PG-13', 1994),
(14, 'The Matrix', 'Sci-Fi', 'R', 1999),
(15, 'Finding Nemo', 'Animation', 'G', 2003),
(16, 'Gladiator', 'Action', 'R', 2000),
(17, 'Titanic', 'Romance', 'PG-13', 1997),
(18, 'The Lion King', 'Animation', 'G', 1994),
(19, 'Jurassic Park', 'Adventure', 'PG-13', 1993),
(20, 'The Shawshank Redemption', 'Drama', 'R', 1994);

INSERT INTO YearStats (Year, TotalGross, Releases)
VALUES
(1972, 250000000, 1),         -- The Godfather
(1993, 1040000000, 1),        -- Jurassic Park
(1994, 1737948916, 3),        -- Forrest Gump, The Lion King, Shawshank
(1997, 2201647264, 1),        -- Titanic
(1999, 466364845, 1),         -- The Matrix
(2000, 460583960, 1),         -- Gladiator
(2003, 940335536, 1),         -- Finding Nemo
(2010, 829895144, 1);         -- Inception



SELECT Movie.Title, YearStats.TotalGross 
FROM Movie 
LEFT JOIN YearStats ON Movie.Year = YearStats.Year; 

SELECT Movie.Title, YearStats.Releases 
FROM YearStats 
RIGHT JOIN Movie ON YearStats.Year = Movie.Year; 

SELECT Movie.Title, YearStats.Year 
FROM Movie 
JOIN YearStats ON Movie.Year = YearStats.Releases;