[SolveSQL] 작품이 없는 작가 찾기

문제 URL : https://solvesql.com/problems/artists-without-artworks/

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

 

*문제 저작권으로 인하여 직접 작성한 쿼리문만 첨부

 

select artist_id, name
from artists
where death_year is not null
and artist_id not in (
  select artist_id from artworks_artists
)

 

서브쿼리를 통한 조건 추가 사용