Im creating a database in SQL and I keep getting errors. Can someone please assist? Here is my full code so far, and Im stuck:

CREATE TABLE CUSTOMER(

CUST_ID VARCHAR(100),

STREET VARCHAR(1000),

ZIPCODE NUMERIC(6,0),

ACC_NO VARCHAR(20) UNIQUE NOT NULL,

CONSTRAINT CUSTOMER_PK PRIMARY KEY (CUST_ID));

CREATE TABLE DISTRIBUTOR(

DISTRIBUTOR_ID VARCHAR(100),

NAME VARCHAR(1000) UNIQUE NOT NULL,

CONSTRAINT DISTRIBUTOR_PK PRIMARY KEY (DISTRIBUTOR_ID));

CREATE TABLE MOVIE( MOVIE_ID VARCHAR(100), DIRECTOR VARCHAR(100) NOT NULL, NAME VARCHAR(100) UNIQUE NOT NULL, TYPE CHAR(1) CHECK (TYPE IN ('C','H','S')), DISTRIBUTOR_ID VARCHAR (100), ACTOR_NAME VARCHAR(100), LENGTH NUMERIC(14,0) CHECK (LENGTH > 0), AWARDS VARCHAR(1000), RATINGS NUMERIC (2,0) CHECK (RATINGS IN (1,2,3,4,5,6,7,8,9,10)), RELEASE_YEAR NUMERIC (4,0), CONSTRAINT MOVIE_PK PRIMARY KEY (MOVIE_ID), CONSTRAINT VIDEO_DVD_FK1 FOREIGN KEY (DISTRIBUTOR_ID) REFERENCES DISTRIBUTOR.DISTRIBUTOR_ID );

CREATE TABLE VIDEO_DVD(

VIDEO_DVD_ID VARCHAR(100),

DISTRIBUTOR_ID VARCHAR(100),

MOVIE_ID VARCHAR(100),

CUSTOMER_ID VARCHAR(100),

FINE_AMT NUMERIC(14,0) CHECK (FINE_AMT > 0),

DAMAGE_CHARGES NUMERIC(14,0) CHECK (DAMAGE_CHARGES > 0),

TYPE CHAR(1) CHECK (TYPE IN ('V','D')),

LEASE_DATE DATE,

RETURN_DATE DATE NOT NULL,

CONSTRAINT VIDEO_DVD_PK PRIMARY KEY (VIDEO_DVD_ID),

CONSTRAINT VIDEO_DVD_FK1 FOREIGN KEY (DISTRIBUTOR_ID) REFERENCES (DISTRIBUTOR.DISTRIBUTOR_ID),

CONSTRAINT VIDEO_DVD_FK2 FOREIGN KEY (MOVIE_ID) REFERENCES (MOVIE.MOVIE_ID),

CONSTRAINT VIDEO_DVD_FK3 FOREIGN KEY (CUSTOMER_ID) REFERENCES (CUSTOMER.CUST_ID));