Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

For UOP course pos 410- here are my instructions for week 4 assignment, do you have an SQL code fo this?

For UOP course pos 410- here are my instructions for week 4 assignment, do you have an SQL code fo this?2. Individual Assignment: 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

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question