Pasted

select distinct p.firstname, p.lastname, 
(select count (*) from filmparticipation fp2,filmitem f2 where fp2.personid=p.personid and f2.filmid=fp2.filmid and f2.filmtype='C') 
from person p, filmparticipation fp, filmitem fi, film f where
fp.parttype = 'director' and fp.personid = p.personid and f.filmid = fp.filmid and fp.filmid = fi.filmid and p.gender = 'F' and fi.filmtype = 'C'
and (select count (*) from filmparticipation fp2,filmitem f2 where fp2.personid=p.personid and f2.filmid=fp2.filmid and f2.filmtype='C') >= 5
order by p.lastname;