[SQL문제풀기 - Advent of SQL 2025 🎅] 한국 감독의 영화 찾기

문제

solvesql.com

https://solvesql.com/problems/find-movies-by-korean-artists/

내가 작성한 정답

MySQL, PostgreSQL, SQLite

select a.name artist, w.title
from artworks w
join artworks_artists c on w.artwork_id = c.artwork_id
join artists a on c.artist_id = a.artist_id and a.nationality = 'Korean'
where w.classification like 'Film%';