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

CREATE TABLE Movie ( 
    ID INT PRIMARY KEY, 
    Title VARCHAR(50), 
    Genre VARCHAR(50), 
    RatingCode VARCHAR(10), 
    Year INT, 
    FOREIGN KEY (Year) REFERENCES YearStats(Year)
    );