sql attempt problem 13 Movies

CREATE DATABASE [Movies]


    CREATE TABLE [Directors](
    [Id] INT(MAX) PRIMARY KEY NOT NULL ,
    [DirectorName] VARCHAR(50),
    [Notes]  VARCHAR(MAX)
    )
     CREATE TABLE [Genres](
    [Id] INT(MAX) PRIMARY KEY  NOT NULL   ,
    [GenreName] VARCHAR(50),
    [Notes]  VARCHAR(MAX)
    )
     CREATE TABLE [Categories](
    [Id] INT(MAX) PRIMARY KEY   NOT NULL ,
    [CategoryName] VARCHAR(50),
    [Notes]  VARCHAR(MAX)
    )
     CREATE TABLE [Movies](
    [Id] INT(MAX) PRIMARY KEY    NOT NULL,
    [Title] VARCHAR(50),
    [DirectorId]  VARCHAR(MAX),
    [CopyrightYear]  YEAR,
    [Length] FLOAT(2,2),
    [GenreId] INT(MAX),
    [CategoryId] INT(MAX),
    [Rating] INT(10),
    [Notes] VARCHAR(MAX),

    )
    INSERT INTO [Directors]([Id],[DirectorName],[Notes])(

        (1,'John',NULL),
        (2,'Stan',NULL),
        (3,'George',NULL),
        (4,'Luke',NULL),
        (5,'Peter',NULL),
    )
     INSERT INTO [Genres]([Id],[GenreName],[Notes])(

        (1,'Action',NULL),
        (2,'Thriller',NULL),
        (3,'Fanatasy',NULL),
        (4,'Sci-Fi',NULL),
        (5,'Comedy',NULL)
    )
     INSERT INTO [Categories]([Id],[CategoryName],[Notes])(

        (1,'Film',NULL),
        (2,'TV Series',NULL),
        (3,'Documentary',NULL),
        (4,'Limited TV Series',NULL),
        (5,'TV Show',NULL)
    )
    INSERT INTO [Movies]([Id],[Title],[DirectorId],[CopyrightYear], [Rating], [Notes])(

        (1,'Superhero Adventure', 1, 2022, 6, NULL),
        (2,'Fighting Justice', 2, 2022, 7, NULL),
        (3,'Strange New Planets', 3, 2022, 8, NULL),
        (4,'The Flying Steel Donkey', 4, 2022, 8, NULL),
        (5,'Mr. Smith and his Umbrella', 5, 2022, 8, NULL)

    )