Another way to solve this problem

Hi Team,

I solved this problem and get similar answer. 

SELECT 
    e.gender, t.title, COUNT(e.emp_no) AS count
FROM
    employees.employees e
        JOIN
    employees.titles t ON e.emp_no = t.emp_no
WHERE
    t.title = 'Manager'
GROUP BY e.gender;