SELECT titles.title,
    count(*) AS total,
    sum(case when employees.gender = 'M' then 1 else 0 end) AS male,
    sum(case when employees.gender = 'F' then 1 else 0 end) AS female
FROM employees
INNER JOIN titles ON employees.emp_no=titles.emp_no
INNER JOIN dept_emp ON employees.emp_no=dept_emp.emp_no
WHERE dept_emp.from_date >= '2005.01.01' AND dept_emp.to_date <= '2020.01.01'
AND employees.hire_date <= '2010.01.01'
GROUP BY titles.title;