Building on the previous database, write queries using the SQL SELECT
statement. Make sure to illustrate the salaries before and after the
modifications (Select *).
„h Sort all employees by payroll, in descending order.
„h Calculate the total payroll of exempt and non-exempt employees
(before & after the adjustments are made).
„h Choose a specific job_title and increase the salary of all individuals
in this category by 0.5%.
„h Increase the remaining employee¡¦s salaries by 2.5%.
„h Add a ¡¥Senior Director¡¦ position to the Job_title table.
„h You discovered that the newly created position should not have
been added to your database. As a result, this information needs to
be deleted from the table.
The HR Department recently submitted a change request. They want the
following information extracted from the database.
„X Calculate the number of exempt and non-exempt employees
there are, by job title. The results should be sorted in
„X Calculate the average salary for all employees.
„X In one query, calculate the average, minimum and maximum
salary for exempt employees.
„X Calculate the difference between the maximum and minimum
salaries for the non-exempt employees.
„X Calculate the minimum salary for exempt employees and the
maximum salary for non-exempt employees.
Using a CASE statement, illustrate:
„h Showing the Employee name and job title, list exempt employees as
¡¥Salaried¡¦ and non-exempt employees as ¡¥Hourl y¡¦.