Discuss the below:
Write SQL SELECT, UPDATE, and DELETE statements.
Using the database and tables, write queries using the SQL SELECT statement.
Note: Select all of the data from both of your tables before you perform the following.
Choose an EEO_1_classification: Increase all employees' salaries that have: the selected EEO_1_classification by 10%.
Increase all employees' salaries by 5%.
Choose an employee from the employee table; delete this employee.
Save the SQL statements and the data from both tables in order to show how the data was affected.
Using the database and tables, write SQL statements to:
Calculate the average salary for all employees.
Calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees.
Calculate the maximum salary for all employees.
Calculate the minimum salary for exempt employees and the maximum salary for non-exempt employees.
Calculate the minimum salary for all employees.
Attachment:- Employee information.rar