Changes

J.Y.S

236 bytes added, 21:06, 19 October 2010

→‎2.

''Saad''

<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 job_id IN ('IT_PROG','ST CLERK')

AND (salary BETWEEN 5000 AND 12000)

/

</pre>

''James''

1

edit