SELECT dir.personid, SUBSTR(dir.firstname,0,20) AS Fornavn, SUBSTR(dir.surname,0,20) AS Etternavn, SUBSTR(COUNT(filmid),0,10) AS Antall
FROM person dir, participation pa, (SELECT COUNT(filmid) AS sub_antall, par.personid AS sub_personid
                                    FROM participation par, person pe
                                    WHERE par.personid = pe.personid
                                    AND par.partname = 'director'
                                    GROUP BY par.personid) sub
WHERE dir.personid = pa.personid
AND dir.personid = sub_personid
AND dir.gender = 'F'
AND pa.partname = 'director'
AND sub_antall > 5
AND EXISTS (SELECT part.personid
            FROM participation part
            WHERE dir.personid IN (SELECT parti.personid
                                   FROM participation parti
                                   WHERE parti.filmid = part.filmid
                                   AND parti.partname = 'director')
            AND part.partname = 'cast'
            AND NOT EXISTS (SELECT partic.filmid
                            FROM participation partic
                            WHERE dir.personid IN (SELECT partici.personid
                                                   FROM participation partici
                                                   WHERE partici.filmid = partic.filmid
                                                   AND partici.partname = 'director')
                            AND part.personid NOT IN (SELECT particip.personid
                                                      FROM participation particip
                                                      WHERE particip.filmid = partic.filmid)))
GROUP BY dir.personid, dir.firstname, dir.surname;