SQL Conditional Salary Update | Dataford Interview Questions

Write a query to update the salary of an employee based on a condition involving the average salary of the entire organization at Eucloid Data Solutions clients.

Use the employees table. For this exercise, increase each employee's salary by 10% when it is below the average non-NULL salary across the organization.

Output

Return one row per updated employee with employee_id, employee_name, and updated_salary.
Order rows by employee_id ascending.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
salary	DECIMAL(12,2)	Current annual salary

Your question is SQL Conditional Salary Update. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem