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)