Show me the salary of team id ATL?
select salary from salary as t1 join team as t2 on t1.team_id = t2.team_id_br where t1.team_id = "ATL"
Show me the league id of player id bedrost01 ?
select distinct t1.league_id from salary as t1 join team as t2 on t1.team_id = t2.team_id_br where t1.player_id = "bedrost01"
Show me the player id with salary 545000?
select distinct t1.player_id from salary as t1 join team as t2 on t1.team_id = t2.team_id_br where t1.salary = 545000