SELECT T1.title FROM albums AS T1 JOIN artists AS T2 ON  T1.artist_id = T2.id WHERE T2.name = "Aerosmith";
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 '' ;
select t1 . title from albums as t1 join artists as t2 on t1 . artist_id = t2 . id where t2 . name = value
What are the titles of all the Aerosmith albums ?