SELECT department_id, count(*) AS employees_no
FROM employee
WHERE gender = 'F'
GROUP BY department_id
HAVING employees_no < 10;
This phrase returns departments where the number of female employees is <10 right, rather than listing female employees from departments that have <10 employees in total?