Programming Homework Help
Programming Homework Help. SQL Help
This is the assignment. Whoever helps to complete I will send you script for the database that is in question. Also need this done fast so if you can do within 24hrs your the one!
Write SQL DML statements that address the following requirements:
Update the Employees table and give all employees making less than $10 per hour a 5% increase.List all records/fields in the EMPLOYEES table in order of the employee’s last name.List all records/fields in the EMPLOYEES table in order of the department name.List employee names, hourly pay rate and department name for employees making between (and including) $10 and $30 per hour.What is the total organization payroll assuming each employee works 40 hours per week?
WHERE clause using comparison operatorsORDER BY clauseJOINSAggregation
Deliverable: One Word document with at least nine queries. For each query include:
SQL in text format (not a screen shot)Screen shots of SQL results
Please submit your assignment.
For assistance with your assignment, please use your text, Web resources, and all course materials.