[SQL문제풀기] 작품이 없는 작가 찾기

문제

solvesql.com

https://solvesql.com/problems/artists-without-artworks/

SQLite

내가 작성한 정답

select distinct t.artist_id, t.name
from artists t
left join artworks_artists w 
on t.artist_id = w.artist_id 
where w.artist_id is null and t.death_year is not null;