SELECT titles.title ,  COUNT(CASE WHEN employees.gender='M'then 1 end) AS Male , COUNT(CASE WHEN employees.gender='F'then 1 end) AS Femail
FROM ((dept_emp INNER JOIN employees ON dept_emp.emp_no=employees.emp_no)INNER JOIN titles ON titles.emp_no=employees.emp_no) GROUP BY titles.title