SQL Database

Use AdventureWorks

1). Produce a list of all employees by Name, Salary, DOB

2. Order by Salaries.

This has to be done by joining the tables in which the ( Name (First,Last), Salary and DOB) colum can be found. So the final result should have four column.

*Note- I have check all the tables and there's no Salary in any of the tables in AdevtureWorks. However, he said that the calculations can be done by using the Rate

HumanResources.EmployeePayHistory

RATE >= $ 8.00

The FirstName and LastName can be found in Person.Person

The Birthdate can be found in HumanResources. Employee

The Rate can be found in the HumanResources.EmployeePayHistory