SELECT Famous_Title FROM artist WHERE Artist_ID NOT IN(SELECT Artist_ID FROM volume)
What are the famous titles of artists who do not have any volumes?
SELECT Famous_Title FROM artist WHERE Artist_ID NOT IN ( SELECT Artist_ID FROM volume )
select famous_title from artist where artist_id not in ( select artist_id from volume )
What are the famous titles of artists who do not have any volumes ?