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.