List Aerosmith's albums.
create table artists (id varchar, name varchar, PRIMARY KEY (id)); create table albums (title varchar, artist_id varchar, PRIMARY KEY (title))
select t1.title from albums as t1 join artists as t2 on t1.artist_id = t2.id where t2.name = "aerosmith"