View the step-by-step solution to:

Individual Assignment: Note. Select all data from both tables before you perform the following:

Individual Assignment: SQL Reports


• Use the database and tables from last week’s assignment to write SQL queries.
• Note. Select all data from both tables before you perform the following:
• Increase all employees’ salaries with the selected EEO-1 classification by 10 percent.
• Increase all employees’ salaries by 5 percent.
• 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.
• Use the database and tables from last week’s assignment to write SQL statements that do the following:
• Calculate the average salary for all employees.
• Calculate the maximum salaries for exempt and non-exempt employees.
• Calculate the maximum salary for all employees.
• Calculate the minimum salaries for exempt and non-exempt employees.
• Calculate the minimum salary for all employees.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question