All pastes #983138 Raw Edit

Something

public sql v1 · immutable
·published 2008-04-13 02:14 UTC
rendered paste body
SELECT	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)