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