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.

• 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

- Please refer to the attachment to answer this question. This question was created from ch7-8 test 1-25.tst.pdf. Additional comments: "Can you please show me

- The domain of y=5f(2x+4)+3 , where f(x) = 1/x is A. X cannot =0 B. X cannot = -2 C. X cannot = -3 D. X cannot = -4

- Carter Company reported the following financial numbers for one of its divisions for the year; average total assets of $4,230,000; sales of $4,655,000; cost of