This exercise is based on the tables shown in the figure from the Adventure Works2008 database. These tables can be found on the SQL server via remote desktop. Department (Huma 9 DepartmentID Name GroupName ModifiedDate EmployeeDepartment History (Hu 9 BusinessEnttyID DepartmentID ShiftID StartDate EndDate ModifiedDate 8 EmployeePay History o Employee (HumanResources) BusinessEntityID Business EntityID RateChangeDate NationalIDNumber Rate LoginID PayFrequency OrganizationNode ModifiedDate OrganizationLevel Job Title BirthDate Marital Status Gender HireDate Please write the SQL statements to answer the following questions. 9. Find the most current pay rate and change date for all employees 1 2 3 4 5 6 7 8 9 10 businessentityid ratechangedate rate 290 2006-07-01 00:00:00.000 23.0769 289 2006-07-01 00:00:00.000 23.0769 288 2007-07-01 00:00:00.000 23.0769 287 2006-05-18 00:00:00.000 48.101 286 2007-07-01 00:00:00.000 23.0769 285 2007-04-15 00:00:00.000 48.101 284 2006-11-01 00:00:00.000 23.0769 283 2005-07-01 00:00:00.000 23.0769 282 2005-07-01 00:00:00.000 23.0769 281 2005-07-01 00:00:00.000 23.0769