Pasted

select distinct p.firstname,p.lastname
from person p, filmitem f, filmparticipation fp where p.personid=fp.personid and fp.filmid=f.filmid and fp.parttype='cast' and
(select count (*) from filmparticipation fp1, filmitem f1 where fp1.personid=p.personid and f1.filmid=fp1.filmid and f1.filmtype='C') > 50 and (select count(*) from filmitem f2 where p.lastname >= (select max(p2.lastname) from person p2, filmparticipation fp2
where fp2.personid=p2.personid and fp2.filmid=f2.filmid and fp2.parttype='cast')) = (select count(*) from filmparticipation fp3 where p.personid=fp3.personid and fp3.parttype='cast');