Hello I need help in running the below code to ensure it works correctly. I need to run the code and see the screenshots of the results from the code being run because I can't get the code to run: CREATE TABLE Project $($

ProjectID INT PRIMARY KEY,

ProjectName VARCHAR$(100),$

Budget DECIMAL$(10,2),$

StartDate DATE,

EndDate DATE

$)$;

CREATE TABLE Task $($

TaskID INT PRIMARY KEY,

ProjectID INT,

TaskDescription VARCHAR$(255),$

TaskStatus VARCHAR$(50),$

AssignedEmployeeID INT,

HoursLogged DECIMAL$(5,2),$

FOREIGN KEY $($ProjectID$)$ REFERENCES Project$($ProjectID$),$

FOREIGN KEY $($AssignedEmployeeID$)$ REFERENCES Employee$($EmployeeID$)$

$)$;

CREATE TABLE Employee $($

EmployeeID INT PRIMARY KEY,

EmployeeName VARCHAR$(100),$

DepartmentID INT

$)$;

CREATE TABLE Department $($

DepartmentID INT PRIMARY KEY,

DepartmentName VARCHAR$(100),$

HourlyRate DECIMAL$(5,2)$

$)$;

CREATE TABLE TimeLog $($

TimeLogID INT PRIMARY KEY,

TaskID INT,

EmployeeID INT,

HoursLogged DECIMAL$(5,2),$

FOREIGN KEY $($TaskID$)$ REFERENCES Task$($TaskID$),$

FOREIGN KEY $($EmployeeID$)$ REFERENCES Employee$($EmployeeID$)$

$)$;

INSERT INTO Project $($ProjectID$,$ ProjectName, Budget, StartDate, EndDate$)$ VALUES

$(1,\text{'}$GCS Infrastructure', $100000,\text{'}2024-01-01\text{'},\text{'}2024-12-31\text{'}),$

$(2,$ 'Tech Upgrade', $50000,\text{'}2024-02-01\text{'},\text{'}2024-09-30\text{'})$;

INSERT INTO Task $($TaskID$,$ ProjectID, TaskDescription, TaskStatus, AssignedEmployeeID, HoursLogged$)$ VALUES

$(1,1,$ 'Database Setup', 'Completed', $101,20),$

$(2,1,$ 'Server Configuration', $\text{'}$In Progress', $102,15),$

$(3,2,$ 'System Testing', 'Completed', $101,30),$

$(4,2,$ 'User Training', $\text{'}$In Progress', $102,10)$;

INSERT INTO Employee $($EmployeeID$,$ EmployeeName, DepartmentID$)$ VALUES

$(101,$ 'Alice', $1),$

$(102,$ 'Bob', $2)$;

INSERT INTO Department $($DepartmentID$,$ DepartmentName, HourlyRate$)$ VALUES

$(1,\text{'}$IT$\text{'},30),$

$(2,$ 'Engineering', $40)$;

INSERT INTO TimeLog $($TimeLogID$,$ TaskID, EmployeeID, HoursLogged$)$ VALUES

$(1,1,101,5),$

$(2,2,102,8),$

$(3,3,101,12),$

$(4,4,102,7)$;

SELECT

p$.$ProjectID,

p$.$ProjectName,

COUNT$($t$.$TaskID$)$ AS TotalTasks,

SUM$($CASE WHEN t$.$TaskStatus $=$ 'Completed' THEN $1$ ELSE $0$ END$)$ AS CompletedTasks,

SUM$($t$.$HoursLogged$)$ AS TotalHours,

COUNT$($DISTINCT e$.$EmployeeID$)$ AS EmployeesInvolved

FROM

Project p

JOIN

Task t ON p$.$ProjectID $=$ t$.$ProjectID

JOIN

Employee e ON t$.$AssignedEmployeeID $=$ e$.$EmployeeID

GROUP BY

p$.$ProjectID, p$.$ProjectName

ORDER BY

p$.$ProjectID;

SELECT

e$.$EmployeeID,

e$.$EmployeeName,

t$.$TaskID,

t$.$TaskDescription,

tl$.$HoursLogged,

t$.$TaskStatus

FROM

Employee e

JOIN

Task t ON e$.$EmployeeID $=$ t$.$AssignedEmployeeID

JOIN

TimeLog tl ON t$.$TaskID $=$ tl$.$TaskID

WHERE

t$.$TaskStatus IN $(\text{'}$In Progress', 'Completed'$)$

ORDER BY

e$.$EmployeeID, t$.$TaskID;

SELECT

p$.$ProjectID,

p$.$ProjectName,

d$.$DepartmentName,

SUM$($tl$.$HoursLogged$)$ AS TotalHours,

p$.$Budget $-$ SUM$($tl$.$HoursLogged $*$ d$.$HourlyRate$)$ AS BudgetRemaining

FROM

Project p

JOIN

Task t ON p$.$ProjectID $=$ t$.$ProjectID

JOIN

Employee e ON t$.$AssignedEmployeeID $=$ e$.$EmployeeID

JOIN

Department d ON e$.$DepartmentID $=$ d$.$DepartmentID

JOIN

TimeLog tl ON t$.$TaskID $=$ tl$.$TaskID

GROUP BY

p$.$ProjectID, p$.$ProjectName, d$.$DepartmentName, p$.$Budget

ORDER BY

p$.$ProjectID, d$.$DepartmentName;