1
edit
Changes
→2.
And upper(job_id) in ('IT_PROG', 'ST_CLERK')
order by employee_id;
</pre>
''FINAL''
<pre>
SELECT 'Employee named ' || first_name || ' ' || last_name || ' who is '
|| job_id || ' will have a new salary of $' || salary * 1.15 "Happy Employees"
FROM employees
WHERE salary BETWEEN 5000 AND 12000
AND UPPER(job_id) IN ('IT_PROG', 'ST_CLERK')
ORDER BY employee_id;
</pre>
