Pasted

mortenkw=> select distinct p.firstname,p.lastname
mortenkw-> from person p, filmitem f, filmparticipation fp where p.personid = fp.personid and fp.filmid = f.filmid and fp.parttype = 'cast' and
mortenkw-> (select count (*) from filmparticipation fp1, filmitem f1 where fp1.personid = p.personid and f1.filmid = fp1.filmid and f1.filmtype = 'C' and
mortenkw(> p.lastname >= (select max(p2.lastname) from person p2, filmparticipation fp2 where fp2.personid = p2.personid and fp2.filmid = f1.filmid and
mortenkw(> fp2.parttype='cast')) > 50;
 firstname  |   lastname
------------+--------------
 Ferdinand  | Zecca
 Léonce     | Perret
 Howard     | Vernon
 Maurice    | Vinot
 Jean       | Wiener
 Alice      | Tissot
 Maurice    | de Féraudy
 William    | Sanders
 Louis      | de Funès
 Georges    | Méliès
 Paul       | Bertho
 Sarah      | Duhamel
 Artus      | de Penguern
 Daniel     | White
 Georges    | Tréville
 Marguerite | de Morlaye
 Charles    | Vanel
 Yvonne     | Yma
 Charles    | Prince
 Gaston     | Modot
 Pierre     | Bressol
 Fernand    | Rivers
 Hubert     | de Lapparent
 Dominique  | Zardi
 Georges    | Van Parys
 Max        | Linder
 Jean       | Tissier
 Romeo      | Bosetti
 Jean       | Yanne
 Henri      | Étiévant
(30 rows)
 mortenkw=>