CREATE TABLE artists (id VARCHAR, name VARCHAR)
CREATE TABLE albums (title VARCHAR, artist_id VARCHAR)

List Aerosmith's 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 "Aerosmith" = "T2"."name" AND "T1"."artist_id" = "T2"."id"