SELECT name, salary, IF(status = 'active', salary * 1.1, salary) AS adjusted_salary FROM employees;