List the names of all artists.
select distinct artist from artist
How many artists have not released any volumes?
select count(*) from artist where artist_id not in(select artist_id from volume)
What are their names?
select artist from artist where artist_id not in(select artist_id from volume)
How about their famous titles?
select famous_title from artist where artist_id not in(select artist_id from volume)