CREATE TABLE player_award (player_id CLOB, award_id CLOB, year NUMBER, league_id CLOB, tie CLOB, notes CLOB)
CREATE TABLE player_award_vote (award_id CLOB, year NUMBER, league_id CLOB, player_id CLOB, points_won NUMBER, points_max NUMBER, votes_first CLOB)
CREATE TABLE hall_of_fame (player_id CLOB, yearid NUMBER, votedby CLOB, ballots CLOB, needed CLOB, votes CLOB, inducted CLOB, category CLOB, needed_note CLOB)
CREATE TABLE player (player_id CLOB, birth_year CLOB, birth_month CLOB, birth_day CLOB, birth_country CLOB, birth_state CLOB, birth_city CLOB, death_year CLOB, death_month CLOB, death_day CLOB, death_country CLOB, death_state CLOB, death_city CLOB, name_first CLOB, name_last CLOB, name_given CLOB, weight CLOB)
CREATE TABLE salary (year NUMBER, team_id CLOB, league_id CLOB, player_id CLOB, salary NUMBER)

What are the salaries in American League?
SELECT salary FROM salary WHERE league_id = "AL"
SELECT "salary" FROM "salary" WHERE "AL" = "league_id"