
using COUNT and GROUP BY with zero-values
Question: I’m trying to query our Human Resources database to find the number of temporary employees in each department. I’m using the following SQL statement: select count (*)from employeewhere status = ‘Temporary’group by departments; I expect the following results: 3004202 but am getting: 3422 That is, the zero-count departments are