What are the titles of all the Aerosmith albums?
select t1.title from albums as t1 join artists as t2 on t1.artist_id = t2.id where t2.name = "Aerosmith";