CREATE TABLE volume (volume_id NUMBER, volume_issue CLOB, issue_date CLOB, weeks_on_top NUMBER, song CLOB, artist_id NUMBER)
CREATE TABLE music_festival (id NUMBER, music_festival CLOB, date_of_ceremony CLOB, category CLOB, volume NUMBER, result CLOB)
CREATE TABLE artist (artist_id NUMBER, artist CLOB, age NUMBER, famous_title CLOB, famous_release_date CLOB)

What are the famous titles of artists who do not have any volumes?
SELECT famous_title FROM artist WHERE NOT artist_id IN (SELECT artist_id FROM volume)
SELECT "famous_title" FROM "artist" WHERE NOT "artist_id" IN (SELECT "artist_id" FROM "volume")