Changes

J.Y.S

No change in size, 00:04, 20 October 2010

→‎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

James.Shaw

1

edit

CDOT Wiki β

Changes

J.Y.S

CDOT Wiki ^β