POS 410 Week 4 Individual Assignment SQL Reports | University of Phoenix
- University of Phoenix / POS 410
- 15 Feb 2019
- Price: $17
- Other / Other
POS 410 Week 4 Individual Assignment SQL Reports | University of Phoenix
POS 410 Week 4 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:
Increase all employees' salaries with the selected EEO-1 classification by 8 percent.
Increase all remaining employees' salaries by 7 percent.
Choose an employee from the Employee table and delete that employee.
Using the LIKE command, list the employees whose last name begins with an "E", "M" or an "T". Then, sort these employees in ascending order.
Calculations. Use the appropriate commands.
Calculate the average salary for all employees.
In one query, calculate the maximum salaries for exempt and non-exempt employees.
Calculate the number of exempt and non-exempt employees there are, by job code. The results should be sorted in descending order.
In one query, calculate the average, minimum and maximum salary for exempt employees. Using the UNION command also display the same information for the non-exempt employees.
Determine if there are any employee's whose salary is below the minimum salary for their job title
Using a CASE statement, illustrate:
Showing the Employee name and job title, list exempt employees as 'Salaried' and non-exempt employees as 'Hourly'.
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:
Increase all employees' salaries with the selected EEO-1 classification by 8 percent.
Increase all remaining employees' salaries by 7 percent.
Choose an employee from the Employee table and delete that employee.
Using the LIKE command, list the employees whose last name begins with an "E", "M" or an "T". Then, sort these employees in ascending order.
Calculations. Use the appropriate commands.
Calculate the average salary for all employees.
In one query, calculate the maximum salaries for exempt and non-exempt employees.
Calculate the number of exempt and non-exempt employees there are, by job code. The results should be sorted in descending order.
In one query, calculate the average, minimum and maximum salary for exempt employees. Using the UNION command also display the same information for the non-exempt employees.
Determine if there are any employee's whose salary is below the minimum salary for their job title
Using a CASE statement, illustrate:
Showing the Employee name and job title, list exempt employees as 'Salaried' and non-exempt employees as 'Hourly'.
USA 
India