Changes

J.Y.S

280 bytes added, 23:54, 19 October 2010

→‎8.

''James''

<pre>

select department_id, department_name, substr(nvl(city,'Not Assigned Yet'),1,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>

1

edit