What is the highest salary among each team? List the team name, id and maximum salary.
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;