List all artists.
select distinct artist from artist
Only list those aged 32 or older.
select distinct artist from artist where age >= 32
Show the information for volumes associated with these artists.
select * from artist as t1 join volume as t2 on t1.artist_id = t2.artist_id where t1.age >= 32
Only show song names.
select t2.song from artist as t1 join volume as t2 on t1.artist_id = t2.artist_id where t1.age >= 32