Cross-Tab: Gender by Department

For each department return the number of male and female employees as columns male and female. Order by department.

Table schema

Employees(id INT PRIMARY KEY, department VARCHAR(20), gender CHAR(1))

Sample data

id | department | gender
1 | Eng | M
2 | Eng | F
3 | Eng | M
4 | HR | F