Fix what is wrong with the current SQL query and ensure it runs without changing the data that would be inserted into the tables:

DROP TABLE IF EXISTS Inspection;

DROP TABLE IF EXISTS Employee;

DROP TABLE IF EXISTS Facility;

CREATE TABLE Facility $($

facility$\_$id INTPRIMARY KEY,

name VARCHAR$(50)$ NOTNULL,

address VARCHAR$(100)$ NOTNULL,

risk$\_$level VARCHAR$(20)$ NOTNULL

$)$;

CREATE TABLE Employee $($

employee$\_$id INTPRIMARY KEY,

name VARCHAR$(50)$ NOTNULL,

title VARCHAR$(50)$ NOTNULL,

salary DECIMAL$(10,2)$ NOTNULL

$)$;

CREATE TABLE Inspection $($

inspection$\_$id INT PRIMARY KEY,

facility$\_$id INT NOT NULL,

employee$\_$id INT NOT NULL,

inspection$\_$date DATE NOT NULL,

results VARCHAR$(50)$ NOT NULL,

FOREIGN KEY $($facility$\_$id$)$ REFERENCES Facility$($facility$\_$id$),$

FOREIGN KEY $($employee$\_$id$)$ REFERENCES Employee$($employee$\_$id$)$

$)$;

NSERT INTO Facility VALUES $(1,$ 'ABC Restaurant', $\text{'}123$ Main St$\text{'},$ 'High'$)$;

INSERT INTO Facility VALUES $(2,\text{'}$XYZ Cafe', $\text{'}456$ Elm St$\text{'},$ 'Medium'$)$;

INSERT INTO Facility VALUES $(3,\text{'}$LMN Bakery', $\text{'}789$ Oak St$\text{'},$ 'Low'$)$;

INSERT INTO Facility VALUES $(4,\text{'}$PQR Deli', $\text{'}101$ Pine St$\text{'},$ 'High'$)$;

INSERT INTO Employee VALUES $(1,$ 'John Doe', 'Inspector', $60000\mathrm{.}00)$;

INSERT INTO Employee VALUES $(2,$ 'Jane Smith', 'Senior Inspector', $75000\mathrm{.}00)$;

INSERT INTO Employee VALUES $(3,$ 'Alice Johnson', 'Inspector', $62000\mathrm{.}00)$;

INSERT INTO Employee VALUES $(4,$ 'Bob Brown', 'Inspector', $58000\mathrm{.}00)$;

INSERT INTO Inspection VALUES $(1,1,1,\text{'}2024-12-01\text{'},$ 'Pass'$)$;

INSERT INTO Inspection VALUES $(2,2,2,\text{'}2024-12-02\text{'},$ 'Fail'$)$;

INSERT INTO Inspection VALUES $(3,3,3,\text{'}2024-12-03\text{'},$ 'Pass'$)$;

INSERT INTO Inspection VALUES $(4,4,4,\text{'}2024-12-04\text{'},$ 'Pass'$)$;

SELECT $*$ FROM Facility;

SELECT $*$ FROM Employee;

SELECT $*$ FROM Inspection;

CREATE VIEW InspectionView AS

SELECT

Inspection.inspection$\_$id$,$

Facility.name AS facility$\_$name,

Employee.name AS inspector$\_$name,

Inspection.inspection$\_$date,

Inspection.results

FROM Inspection

JOIN Facility ON Inspection.facility$\_$id $=$ Facility.facility$\_$id

JOIN Employee ON Inspection.employee$\_$id $=$ Employee.employee$\_$id;