List the names of all songs.
select song from volume
Which songs were featured at music festivals?
select t2.song from music_festival as t1 join volume as t2 on t1.volume = t2.volume_id
Which ones have the result “nominated”?
select t2.song from music_festival as t1 join volume as t2 on t1.volume = t2.volume_id where t1.result = "Nominated"