var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: directors, actors, films (was "SqlPlus query. Need some help")
What i want to find is the following:
Find first and lastname for all female directors who have directed more than 5 movies,
and have used the same actor in all of their movies.
I've done the first part of this query which lists female directors with more than 5 movies:
select firstname, lastname
where gender = 'F' AND personid in
(select personidorder by surname;
where partname = 'director'
group by personid
Now, how do I find the directors that have used the same actor in all of their movies?
Last edited by dbnewbee; 04-23-06 at 20:28.
how do you define an actor? and when you say "have used the same actor in all of their movies" does this mean any actor or all actors?
by the way, you shouldn't have participation_id as the primary key of Participation -- the primary key should consist of the pair of columns person_id, film_id
1. an actor is defined to participate in a film whenever partname = 'actor'.
2. Any actor is sufficient