Provide the SQL query that allows you to display how many male managers and female managers work for each department. Make sure to display the gender, the number of employees (renamed as num_empGender) and dept_no, order by department number in an ascendant order.
a) SELECT gender, COUNT() AS numâ‚‘mpGender, deptâ‚™o FROM employees WHERE gender = 'Male' OR gender = 'Female' GROUP BY gender, deptâ‚™o ORDER BY deptâ‚™o ASC
b) SELECT gender, COUNT() AS numâ‚‘mpGender, deptâ‚™o FROM employees WHERE gender = 'Male' AND gender = 'Female' GROUP BY gender, deptâ‚™o ORDER BY deptâ‚™o ASC
c) SELECT gender, COUNT() AS numâ‚‘mpGender, deptâ‚™o FROM employees WHERE gender IN ('Male', 'Female') GROUP BY gender, deptâ‚™o ORDER BY deptâ‚™o ASC
d) SELECT gender, COUNT() AS numâ‚‘mpGender, deptâ‚™o FROM employees WHERE gender = 'Male' XOR gender = 'Female' GROUP BY gender, deptâ‚™o ORDER BY deptâ‚™o ASC