For each team, return the team name, id and the maximum salary among the team.
select t1.name, t1.team_id, max(t2.salary) from team as t1 join salary as t2 on t1.team_id = t2.team_id group by t1.team_id;