One row per dept_id (employees with a department) with columns male and female — the head count of each gender.
dept_id
male
female
5 rows with columns dept_id, male, female
Run your code to see the output here.