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. 10. Show the pay rate and the difference between the pay rate and the average rate of the company for all employees businessentityid 12 12 3 3 4 4 5 4 6 4 7 5 8 6 9 7 10 8 von AWNI- rate difference 125.50 107.7412 63.4615 45.7027 43.2692 25.5104 8.62 -9.1388 23.72 5.9612 29.8462 12.0874 32.6923 14.9335 32.6923 14.9335 50.4808 32.722 40.8654 23.1066