Hi.
I'd like to select * from an Department table and also include a column that is a count() of Employees in each Department. The Department table (simplified) includes a unique Dept_ID and Description. Each Employee in the [Emp] table has a "Dept_ID" column, indicating which department the employee is in.
So, in the end, I'd like a resultset something like: