CREATE TABLE ARTIST (ArtistId VARCHAR2, Name VARCHAR2)
CREATE TABLE ALBUM (ArtistId VARCHAR2)

Find the title of all the albums of the artist 'AC/DC'.
SELECT Title FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId = T2.ArtistId WHERE T2.Name = "AC/DC"
SELECT "Title" FROM "ALBUM" "T1" JOIN "ARTIST" "T2" ON "AC/DC" = "T2"."Name" AND "T1"."ArtistId" = "T2"."ArtistId"