SQL Reports
• Use the database and tables from last week’s assignment to write SQL queries using the SQL SELECT statement.
• Note. 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.
• Use the database and tables from last week’s assignment to 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.
• Print out the SQL statements and results. Be prepared to demonstrate your results in class.
