Y Graded Exercise 6 Use Spark SQL to return Column 1-salary level Column 2 - number of employees with a salary level in column 1 Navigate to Manage-> Environmental Runtimes and

record 1) Total account capacity unit hours used and 2) Remaining account capacity unit hours on the Spark Tutorial answer sheet. 3) Answer the follow up questions on the assignment answer sheet Ungraded Exercise 1 Use Spark SQL to return Column 1-department name Column 2 - salary level Column 3-number of retained employees who work for the department in column 1 and have a salary level in column 2 Sort the retuned data by department name Ungraded Exercise 2 Use Spark SQL to return Column 1-department name Column 2-salary level Column 3-attrition Column 4-number of employees who work/worked for the department in column 1 with a salary level in column 2 and attrition status in column 3 Sort the retuned data by department name Ungraded Exercise 3 Use Spark SQL to return Column 1-department name Column 2 - number of retained employees from department in column 1 Column 3-number of employees who left from department in column 1 Column 4-total number of employees from department in column 1 Sort the retuned data by department name