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.

"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!":

Get started