CS50_Labs/Lab7/movies/9.sql

4 lines
154 B
SQL

select distinct name from people
join stars on people.id = stars.person_id
where movie_id in (select id from movies where year = 2004)
order by birth asc;