Write SQL DML statements that address the following requirements

Write SQL DML statements that address the following requirements:

 

1. Update the Employees table and give all employees making less than $10 per hour a 5% increase.
2. List all records/fields in the EMPLOYEES table in order of the employee’s last name.
3. List all records/fields in the EMPLOYEES table in order of the department name.
4. List employee names, hourly pay rate and department name for employees making between (and including) $10 and $30 per hour.