1
edit
Changes
→8.
''James''
<pre>
select department_id, department_name, substr(nvl(city,'Not Assigned Yet'),1,25) City, count(DISTINCT distinct job_id) '"# of Jobs'"from employeesright outer join departments
using (department_id)
left outer join locations
