SELECT 'Employee named ' || first_name || ' ' || last_name || ' who is ' || job_id || \ ' will have a new salary of $' || salary*1.15 "Happy Employees"

WHERE salary BETWEEN 5000 AND 12000AND job_id IN ('IT_PROG', 'ST_CLERK')ORDER BY salaryemployee_id;