Something

-- 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 malesSELECT	DISTINCT m.id, m.name FROM	Actor as a, Cast as c, Movie as mWHERE	(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)