Which SQL query will correctly raise the salary by 10% for employees in the…

1. A.

   MODIFY employees SET salary = salary + 10% WHERE department = 'HR' AND salary < 50000;

2. B.

   UPDATE employees SET salary = salary * 1.10 WHERE department = 'HR' AND salary < 50000;

3. C.

   UPDATE employees SET salary = salary * 10% WHERE department = 'HR';

4. D.

   UPDATE employees SET salary = salary + 5000 IF department = 'HR' AND salary < 50000;

Attempted by 80 students.