How many female students joined a marines and air force organization?
joined a marines refers to organ = 'marines'; air force organization refers to organ = 'air_force';
SELECT COUNT(name) FROM enlist WHERE organ IN ('marines', 'air_force') AND name NOT IN ( SELECT name FROM male )