CREATE TABLE invoice_lines (id NUMBER, invoice_id NUMBER, track_id NUMBER, unit_price NUMBER, quantity NUMBER)
CREATE TABLE artists (id NUMBER, name CLOB)
CREATE TABLE sqlite_sequence (name CLOB, seq CLOB)
CREATE TABLE playlists (id NUMBER, name CLOB)
CREATE TABLE employees (id NUMBER, last_name CLOB, first_name CLOB, title CLOB, reports_to NUMBER, birth_date TIME, hire_date TIME, address CLOB, city CLOB, state CLOB, country CLOB, postal_code CLOB, phone CLOB, fax CLOB, email CLOB)
CREATE TABLE playlist_tracks (playlist_id NUMBER, track_id NUMBER)
CREATE TABLE genres (id NUMBER, name CLOB)
CREATE TABLE customers (id NUMBER, first_name CLOB, last_name CLOB, company CLOB, address CLOB, city CLOB, state CLOB, country CLOB, postal_code CLOB, phone CLOB, fax CLOB, email CLOB, support_rep_id NUMBER)
CREATE TABLE albums (id NUMBER, title CLOB, artist_id NUMBER)
CREATE TABLE invoices (id NUMBER, customer_id NUMBER, invoice_date TIME, billing_address CLOB, billing_city CLOB, billing_state CLOB, billing_country CLOB, billing_postal_code CLOB, total NUMBER)
CREATE TABLE tracks (id NUMBER, name CLOB, album_id NUMBER, media_type_id NUMBER, genre_id NUMBER, composer CLOB, milliseconds NUMBER, bytes NUMBER, unit_price NUMBER)
CREATE TABLE media_types (id NUMBER, name CLOB)

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" "T1" JOIN "artists" "T2" ON "Aerosmith" = "T2"."name" AND "T1"."artist_id" = "T2"."id"