Update Salary for Sales Employees | Dataford Interview Questions

Update salary by 10% for Sales department employees.

Asked in the technical stage. This was a live SQL round using an Employees/Departments schema, with screen sharing and the query output pasted in chat.

Output

Update only employees assigned to the Sales department.
Return employee_id, employee_name, and the resulting updated_salary for each affected employee.
Sort returned rows by employee_id ascending.

Schema

employees

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

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department name

Your question is Update Salary for Sales Employees. Start with the requirements and the two tables 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