Write SQL queries using the SQL SELECT statement.
Select all data from both tables before you perform the following:
o Increase all employees' salaries with the selected EEO-1 classification by 10 percent.
o Increase all employees' salaries by 5 percent.
o Choose an employee from the Employee table and delete that employee.
• Print out the SQL statements and data from both tables to show how data was affected. Be prepared to demonstrate your results in class.
Write SQL statements that do the following:
o Calculate the average salary for all employees.
o Calculate the maximum salaries for exempt and non-exempt employees.
o Calculate the maximum salary for all employees.
o Calculate the minimum salaries for exempt and non-exempt employees.
o Calculate the minimum salary for all employees.