Question

Display the list of all departments, with the total number of instructors in each department, without using scalar subqueries. make sure to correctly handle departments with no instructors.

Is this the right answer:
select department.dept_name
from department natural left outer join
instructor.ID;