SQL query to generate report of employees grouped by department with count

• Use JOIN to combine employee and department tables

• Group by department to get count of employees in each department

• Select depar...read more