CS50_Labs/Lab7/movies/10.sql

4 lines
153 B
SQL

select distinct name from people
join directors on people.id = directors.person_id
where movie_id in (select movie_id from ratings where rating >= 9.0);