Count employees per department, including departments with zero employees.

Answer preview

LEFT JOIN from departments and count a column from the employee side — COUNT(e.emp_id), never COUNT(*).…