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

문제

solvesql.com

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

SQLite

내가 작성한 정답

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