Changes

J.Y.S

327 bytes added, 20:10, 16 October 2010

→‎8.

''YuJin''

<pre>

SELECT department_id, department_name,

RPAD(TRIM(NVL(city, 'Not Assinged Yet')), 25, ' ') "City",

COUNT(DISTINCT job_id) "# of Jobs"

FROM employees

RIGHT OUTER JOIN departments USING (department_id)

LEFT OUTER JOIN locations USING (location_id)

GROUP BY department_id, department_name, city;

</pre>

''Saad''

1

edit