Find the titles of all the albums of the artist Aerosmith please?
SELECT Title FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId   =   T2.ArtistId WHERE T2.Name   =  "Aerosmith"
titles of all the albums refers to SELECT Title; artist Aerosmith refers to WHERE Name = 'Aerosmith'; JOIN operation is used to link albums to their respective artist.