Having this database in MS Access Write SQL queries for Li

Having this database in MS Access

Write SQL queries for :

* List movies that were re-made (have same title)

* List actors with the most number of movies released in a year

* List actors who co-starred together at least 9 times

* List actors who have been directed only by those directors who directed \"Clint Eastwood\"

Solution

1.select m.title from Movies m

where m.id in (select d.movieid from DirectedBy d);

2.select a.actor from Actors a

where a.actorid in(select i.actorid from ActedIn i

having max(i.actedinid) and

i.movieid in(select m.id from Movies m where year=2000);

3.select a.actor from Actors a

where a.actorid in(select i.actorid from ActedIn i

having count(i.actedinid)>=9 and

i.movieid in(select m.id from Movies m);

4.select a.actor from Actors a

where a.actorid in(select i.actorid from ActedIn i

where i.movieid in(select d.movieid from DirectedBy d

where d.directorid in(select d1.directorid from Directors d1

where d1.directorid in(select d.directedid from DirectedBy d

where d.movieid in(select m.id from Movies where title=\"Clint Eastwood\");