Mopteh icon

3.4

Mopteh | PRO | 03/11/10 08:26:54 PM UTC | 0 ⭐ | 225 👁️ | Never ⏰ | []
text |

480 B

|

None

|

0 👍

/

0 👎

select distinct p.firstname, lastname from person p 
where p.gender = 'F' and 
	(select count(*) from filmparticipation fp where
	fp.personid = p.personid and fp.parttype = 'director') > 5 and
exists 
	(select * from person p2 where all
		(select * from filmparticipation fp, filmparticipation fp2, filmitem f where
		p.personid = fp.personid and p2.personid = fp2.personid and
		f.filmid = fp2.filmid and f.filmid = fp.filmid and fp.parttype = 'director'
		and fp2.parttype = 'cast'));

Comments