SELECT AVG(NUMBER)
FROM (SELECT t.TEAM_ID, TEAM_NAME, COUNT(EMPLOYEE_ID) AS NUMBER
FROM TEAMS t
LEFT JOIN EMPLOYEES emp ON t.TEAM_ID = emp.TEAM_ID AND GENDER='F'
GROUP BY t.TEAM_ID, TEAM_NAME)s