(1)Using the data from last week, display all data from both tables to provide a baseline for the remainder of the queries. The output from the Jobs_Title table query should be ordered by the Job Title. The output from the Employee query should be ordered by Last Name.
(2)Increase all employees' salaries with a specific EEO-1 classification by 10 percent.
(3)Increase all employees' salaries by 5 percent.
(4)Choose an employee and yourself from the Employee table and delete these two employees with one command.
(5)Provide a query that proves that those two were in fact, deleted. Hint: Use COUNT.
(6)Calculate the average salary for all employees.
(7)Calculate the maximum salaries for exempt and non-exempt employees. Hint: A single query is required and it will the 'GROUP BY' clause.
(8)Calculate the maximum salary for all employees.
(9)Calculate the minimum salaries for exempt and non-exempt employees.
(10)In single query display the average age, maximum age, and minimum age of all of the employees. Make sure to label each column output so as to know which value goes with which calculation.
Provide the SQL and screen shot of the results of each of the above.