I need help creating a query for all employees:

Employee ID

First and Last Name

Department Name

Current Salary

Last Raise Date

We kindly ask that you provide us with this report by May $17$ th$,2023$ so that we can review and analyze the data.

dbo.ErrorLog

HumanResources. Department

Columns

$$ DepartmentID $($PK$,$ smallint,

SQLQuery$3.$sql $-$ SHI...$($SHIELAlshiel $(55))*+$ SQLQuery$2.$sql $-$ not connected

SQLQuery$1.$sql $-$ not connected

player$\_$db$.$sql $-$ not connected

SELECT E$.$HumanResources.EmployeePayHistory, E$.$HumanResources.Department,

E$.$Name, E$.$BusinessEntityID AS EmployeeID, E$.$DepartmentID, E$.$SalariedFlat, E$.$RateChangeDate AS RC$.$Rate AS CurrentSalary, MD$.$ModifiedDate AS LastRaiseDate FROM EmployeePayHistory AS E$,$ Department AS H INNER JOIN Departments d ON e$.$DepartmentID $=$ d$.$DepartmentID

WHERE LastRaiseDate $$ DATEADD$($month$,-12,$ GETDATE$())$ OR LastRaiseDate IS NULL ORDER BY

e$.$Name;

$$ Name $($Name$($nvarchar$(50)),$

G GroupName $($Name$($nvarcha

$$ ModifiedDate $($datetime$,$ no

HumanResources.Employee

HumanResources.EmployeeDep

HumanResources.EmployeePay$$

E Columns

BusinessEntityID $($PK$,$ FK$,$ int

$100\%$

Messages

Msg $102,$ Level $15,$ State $1,$ Line $1$

Incorrect syntax near $\text{'}.$

RateChangeDate $($PK$,$ dateti

$$ Rate $($money$,$ not null$)$

$$ PayFrequency $($tinyint$,$ not $n$

B ModifiedDate $($datetime$,$ no

Completion time: $2024-05-1021$:$20$:$12\mathrm{.}1115254-05$:$00$

Please include the following features in your report.

Include our company logo$.$

Include a title of the report named Employee Salary History.

Flag any employee who has not had a raise in over $12$ months. You can either color code the output or create a widget indicator.

Include all the information mentioned above.

Make the report sortable by the employee's last name.

We would also like an export of the report in Excel format to share with our coworkers. I have to filter out employees who have not had a raise in $12$ months or more.

This is what i have for a query but cannot get it to work