i wrote another solution for this assigment which have the same result which the given answer

Another solution for this assigment which has the same result:

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