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

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

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