Question

Write a query to display the names of all the department and the staff count in each department, if there are no staffs in the department, display the count as 0. Give an alias to staff count as STAFF_COUNT. Sort the result based on department name.

Refer to the schema below

Answer 1

Explanation:

A few mixtures are given below. Tabulate the methods to separate their components and give the reasons for selecting the method