AdventureWorks Employee details using JOINS

/* Find the Employee details like Name,department,shift....... from AdventureWorks database */


SELECT
H.EmployeeID,
C.FirstName+' '+C.LastName AS FULL_NAME,
D.Name AS DEPARTMENT_NAME,
S.Name AS SHIFT_TYPE,
CONVERT(VARCHAR(15),S.StartTime,108)AS StartTime,
CONVERT(VARCHAR(10),S.EndTime,108) AS EndTime,
P.PayFrequency,
P.Rate
FROM HumanResources.EmployeeDepartmentHistory H
JOIN
HumanResources.Employee E
ON H.EmployeeID = E.EmployeeID
JOIN
Person.Contact C
ON E.ContactID = C.ContactID
JOIN
HumanResources.Department D
ON D.DepartmentID = H.DepartmentID
JOIN
HumanResources.Shift S
ON S.ShiftID = H.ShiftID
JOIN
HumanResources.EmployeePayHistory P
ON P.EmployeeID = E.EmployeeID