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. Google and learn about the SQL functions Datepart and Datename. Use this function to show the number of employees hired by day of the week 1 2 3 4 weekday number of hires 1 42 2 42 3 31 4 47 5 43 5 6 6 49 7 7 36 Or 1 2 3 weekday Friday Monday Saturday Sunday Thursday Tuesday Wednesday number of hires 49 42 36 42 43 31 4 5 6 7 47