i need help creating $anSQL$ Statement, all the Solutions found $on$ this provide invalid $SQL$ statementsCREATE TABLE Officer $($

OfficerNumber INT UNSIGNED AUTO$\_$INCREMENT,

BadgeNumber INT NOT NULL,

DepartmentName VARCHAR$(30)$ NOT NULL,

FullName VARCHAR$(30)$ NOT NULL,

RankCode CHAR$(3),$

PRIMARY KEY $($OfficerNumber$),$

UNIQUE $($BadgeNumber$,$ DepartmentName$)$

$)$;

CREATE TABLE Event $($

EventNumber INT UNSIGNED AUTO$\_$INCREMENT,

EventDateTime DATETIME NOT NULL,

LocationDesc TEXT$(1000)$ NOT NULL,

ReportDesc TEXT$(5000),$

EventCode CHAR$(2)$ NOT NULL,

CauseEventNumber INT UNSIGNED,

ReportOfficerNumber INT UNSIGNED NOT NULL,

PRIMARY KEY $($EventNumber$),$

FOREIGN KEY $($CauseEventNumber$)$

REFERENCES Event $($EventNumber$)$

ON UPDATE SET NULL

ON DELETE SET NULL,

FOREIGN KEY $($ReportOfficerNumber$)$

REFERENCES Officer $($OfficerNumber$)$

ON UPDATE RESTRICT

ON DELETE RESTRICT

$)$;

CREATE TABLE Vehicle $($

Vehicle ID INT UNSIGNED AUTO$\_$INCREMENT PRIMARY KEY,

TypeCode CHAR$(1)$ NOT NULL,

YearNumber INT UNSIGNED NOT NULL,

MakeCode CHAR$(1)$ NOT NULL,

ModelName VARCHAR$(20)$ NOT NULL,

PlateID INT UNSIGNED,

StateCode CHAR$(2)$ NOT NULL,

RegistrationDate DATE

CONSTRAINT fk$\_$PlateID FOREIGN KEY $($PlateID$)$ REFERENCES Plate$($PlateID$)$

$)$;

CREATE TABLE Vehicle Event $($

EventNumber INT UNSIGNED AUTO$\_$INCREMENT PRIMARY KEY,

VehicleID INT UNSIGNED NOT NULL,

EventDate DATE NOT NULL,

TimeTIME NOT NULL,

LocationDesc VARCHAR $(255)$ NOT NULL,

ReportDesc TEXT,

Officer Number INT UNSIGNED,

EventCode CHAR$(1)$ NOT NULL,

CauseEventNumber INT UNSIGNED,

CONSTRAINT fk$\_$VehicleID FOREIGN KEY $($VehicleID$)$ REFERENCES Vehicle$($VehicleID$),$

CONSTRAINT fk$\_$OfficerNumber FOREIGN KEY $($OfficerNumber$)$ REFERENCES Officer$($OfficerNumber$),$

CONSTRAINT fk$\_$CauseEventNumber FOREIGN KEY $($CauseEventNumber$)$ REFERENCES CauseEvent$($CauseEventNumber$)$

$)$;

please review the last expert answer which i incuded here and $it$ was incorrect.

please provide the correct SQL in the proper format, the previous answers themselves had syntax issues and spacing issues

CREATE TABLE Officer $($

OfficerNumber INT UNSIGNED AUTO$\_$INCREMENT,

BadgeNumber INT NOT NULL,

DepartmentName VARCHAR$(30)$ NOT NULL,

FullName VARCHAR$(30)$ NOT NULL,

RankCode CHAR$(3),$

PRIMARY KEY $($OfficerNumber$),$

UNIQUE $($BadgeNumber$,$ DepartmentName$)$

$)$;

CREATE TABLE Event $($

EventNumber INT UNSIGNED AUTO$\_$INCREMENT,

EventDateTime DATETIME NOT NULL,

LocationDesc TEXT$(1000)$ NOT NULL,

ReportDesc TEXT$(5000),$

EventCode CHAR$(2)$ NOT NULL,

CauseEventNumber INT UNSIGNED,

ReportOfficerNumber INT UNSIGNED NOT NULL,

PRIMARY KEY $($EventNumber$),$

FOREIGN KEY $($CauseEventNumber$)$

REFERENCES Event $($EventNumber$)$

ON UPDATE SET NULL

ON DELETE SET NULL,

FOREIGN KEY $($ReportOfficerNumber$)$

REFERENCES Officer $($OfficerNumber$)$

ON UPDATE RESTRICT

ON DELETE RESTRICT

$)$;

CREATE TABLE Vehicle $($

Vehicle ID INT UNSIGNED AUTO$\_$INCREMENT PRIMARY KEY,

TypeCode CHAR$(1)$ NOT NULL,

YearNumber INT UNSIGNED NOT NULL,

MakeCode CHAR$(1)$ NOT NULL,

ModelName VARCHAR$(20)$ NOT NULL,

PlateID INT UNSIGNED,

StateCode CHAR$(2)$ NOT NULL,

RegistrationDate DATE

CONSTRAINT fk$\_$PlateID FOREIGN KEY $($PlateID$)$ REFERENCES Plate$($PlateID$)$

$)$;

CREATE TABLE Vehicle Event $($

EventNumber INT UNSIGNED AUTO$\_$INCREMENT PRIMARY KEY,

VehicleID INT UNSIGNED NOT NULL,

EventDate DATE NOT NULL,

TimeTIME NOT NULL,

LocationDesc VARCHAR $(255)$ NOT NULL,

ReportDesc TEXT,

Officer Number INT UNSIGNED,

EventCode CHAR$(1)$ NOT NULL,

CauseEventNumber INT UNSIGNED,

CONSTRAINT fk$\_$VehicleID FOREIGN KEY $($VehicleID$)$ REFERENCES Vehicle$($VehicleID$),$

CONSTRAINT fk$\_$OfficerNumber FOREIGN KEY $($OfficerNumber$)$ REFERENCES Officer$($OfficerNumber$),$

CONSTRAINT fk$\_$CauseEventNumber FOREIGN KEY $($CauseEventNumber$)$ REFERENCES CauseEvent$($CauseEventNumber$)$

$)$;

the last submission provided these errors please provide SQL statement without these errors

Latest submission $-3$:$33$ PM CST on $02/11/24$

Total score: $0/10$

Download this submission

$1$:Test Vehicle primary key

$0/1$

Query failed: ERROR $1824($HY$000)$ at line $30$: Failed to open the referenced table 'plate'

$2$:Test multiple Vehicle columns

$0/2$

Query failed: ERROR $1824($HY$000)$ at line $30$: Failed to open the referenced table 'plate'

$3$:Test Vehicle unique columns

$0/2$

Query failed: ERROR $1824($HY$000)$ at line $30$: Failed to open the referenced table 'plate'

$4$:Test VehicleEvent primary key

$0/3$

Query failed: ERROR $1824($HY$000)$ at line $30$: Failed to open the referenced table 'plate'

$5$:Test restrict rules for VehicleID

$0/1$

Query failed: ERROR $1824($HY$000)$ at line $30$: Failed to open the referenced table 'plate'

$6$:Test restrict rules for EventNumber

$0/1$

Query failed: ERROR $1824($HY$000)$ at line $30$: Failed to open the referenced table 'plate'