Something
public sql v1 · immutableSELECT 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)