You want to increase the salary by 10% for employees with salary below 4000 and get their new salaries. Which query correctly does this?

hard📝 Application Q8 of 15

PostgreSQL - Set Operations and Advanced Queries

AUPDATE employees SET salary = salary * 1.1 WHERE salary < 4000 RETURNING id, salary;

BUPDATE employees RETURNING id, salary SET salary = salary * 1.1 WHERE salary < 4000;

CUPDATE employees SET salary = salary * 1.1 WHERE salary < 4000;

DUPDATE employees SET salary = salary * 1.1 RETURNING id, salary WHERE salary < 4000;

Step-by-Step Solution

Solution:

Step 1: Confirm correct UPDATE syntax with WHERE and RETURNING
RETURNING must come after SET and WHERE clauses.
Step 2: Validate UPDATE employees SET salary = salary * 1.1 WHERE salary < 4000 RETURNING id, salary;
UPDATE employees SET salary = salary * 1.1 WHERE salary < 4000 RETURNING id, salary; correctly updates salaries below 4000 and returns id and new salary.
Final Answer:
UPDATE employees SET salary = salary * 1.1 WHERE salary < 4000 RETURNING id, salary; -> Option A
Quick Check:
Correct order: SET, WHERE, RETURNING [OK]

Quick Trick: RETURNING must follow WHERE clause in UPDATE [OK]

Common Mistakes:

Master "Set Operations and Advanced Queries" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free