-- Relevant tables are:
--    * ACTOR (id, fname, lname, gender)
--    * MOVIE (id, name, year, rank)
--    * DIRECTORS (id, fname, lname)
--    * CAST (pid, mid, role)
--    * MOVIE_DIRECTORS (did, mid)
--
-- question is which movies have more females in the cast than males

SELECT	DISTINCT m.id, m.name 
FROM	Actor as a, Cast as c, Movie as m
WHERE	(SELECT COUNT(*)
	 WHERE a.gender = 'F'
	   AND m.id = c.mid
	   AND a.id = c.pid) >
	(SELECT COUNT(*)
	 WHERE a.gender = 'M'
	   AND m.id = c.mid
	   AND a.id = c.pid)