What are the titles of albums by the artist "AC/DC"?
SELECT Title FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId  =  T2.ArtistId WHERE T2.Name  =  "AC/DC"
titles of albums by the artist \"AC/DC\" refers to SELECT Title WHERE Name = \"AC/DC\"; involves a JOIN between album and artist tables on ArtistId;