One row per dept_id (employees with a department) with columns male and female — the head count of each gender.
dept_id
male
female
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.