BEGIN
  UPDATE tblEmployeeA9
  SET AnnualSalary = ROUND(1.02*AnnualSalary, -2)
  WHERE JobTitle LIKE '%Manager%' AND Active = 'Y'

  UPDATE tblEmployeeA9
  SET AnnualSalary = ROUND(1.1*AnnualSalary, -2)
  WHERE (JobTitle LIKE '%Clerk%') AND (JobTitle NOT LIKE '%Manager%') AND (Active = 'Y')

  UPDATE tblEmployeeA9
  SET AnnualSalary = ROUND(1.05*AnnualSalary, -2)
  WHERE JobTitle NOT LIKE '%Clerk%' AND JobTitle NOT LIKE '%Manager%' AND Active = 'Y'
END