-- actors who have been directed by Clint Eastwood,
-- implemented using subqueries

use wmdb;

select name
from person
where nm in (
	select nm
	from credit
	where tt in (
		select tt
		from movie
		where director = (
			select nm
			from person
			where name = 'Clint Eastwood')));