SELECT Famous_Title FROM artist WHERE Artist_ID NOT IN(SELECT Artist_ID FROM volume)
Find the famous titles of artists that do not have any volume.
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 )
Find the famous titles of artists that do not have any volume .