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