This exercise is based on the tables shown in the figure from the Adventure Works 2008 database. These tables can be found on the SQL server via remote desktop. Department (Huma 9 DepartmentID Name GroupName ModifiedDate Employee Department History (Hu 8 Business EntryID 8 DepartmentID Shift 9 StartDate EndDate ModifiedDate 8 EmployeePay History - Employee (Human Resources) BusinessEntryID 8 Business EntityID RateChangeDate National DNumber Rate LoginID PayFrequency Organization Node Modifled Date OrganizationLevel Job Title BirthDate Marital Status Gender HireDate Please write the SQL statements to answer the following questions. 9. Google and learn about the SQL function "Case...When...End". Use this function to show the number of female, male, and total number of current employees Female Male Total 84 206 290 1