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;
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;
[{'name': 'Anaheim Angels', 'team_id': 'ANA', 'max(T2.salary)': 13166667}, {'name': 'Arizona Diamondbacks', 'team_id': 'ARI', 'max(T2.salary)': 16000000}, {'name': 'Atlanta Braves', 'team_id': 'ATL', 'max(T2.salary)': 16061802}, {'name': 'Baltimore Orioles', 'team_id': 'BAL', 'max(T2.salary)': 17000000}, {'name': 'Boston Americans', 'team_id': 'BOS', 'max(T2.salary)': 22500000}, {'name': 'California Angels', 'team_id': 'CAL', 'max(T2.salary)': 5375000}, {'name': 'Chicago White Sox', 'team_id': 'CHA', 'max(T2.salary)': 17000000}, {'name': 'Chicago White Stockings', 'team_id': 'CHN', 'max(T2.salary)': 20000000}, {'name': 'Cincinnati Reds', 'team_id': 'CIN', 'max(T2.salary)': 18910655}, {'name': 'Cleveland Blues', 'team_id': 'CLE', 'max(T2.salary)': 15000000}, {'name': 'Colorado Rockies', 'team_id': 'COL', 'max(T2.salary)': 20275000}, {'name': 'Detroit Tigers', 'team_id': 'DET', 'max(T2.salary)': 28000000}, {'name': 'Florida Marlins', 'team_id': 'FLO', 'max(T2.salary)': 14936667}, {'name': "Houston Colt .45's", 'team_id': 'HOU', 'max(T2.salary)': 19369019}, {'name': 'Kansas City Royals', 'team_id': 'KCA', 'max(T2.salary)': 13500000}, {'name': 'Los Angeles Angels', 'team_id': 'LAA', 'max(T2.salary)': 26187500}, {'name': 'Los Angeles Dodgers', 'team_id': 'LAN', 'max(T2.salary)': 32571000}, {'name': 'Miami Marlins', 'team_id': 'MIA', 'max(T2.salary)': 19000000}, {'name': 'Milwaukee Brewers', 'team_id': 'MIL', 'max(T2.salary)': 16000000}, {'name': 'Minnesota Twins', 'team_id': 'MIN', 'max(T2.salary)': 23000000}, {'name': 'Milwaukee Brewers', 'team_id': 'ML4', 'max(T2.salary)': 5875000}, {'name': 'Montreal Expos', 'team_id': 'MON', 'max(T2.salary)': 11500000}, {'name': 'New York Highlanders', 'team_id': 'NYA', 'max(T2.salary)': 33000000}, {'name': 'New York Mets', 'team_id': 'NYN', 'max(T2.salary)': 23145011}, {'name': 'Oakland Athletics', 'team_id': 'OAK', 'max(T2.salary)': 13500000}, {'name': 'Philadelphia Quakers', 'team_id': 'PHI', 'max(T2.salary)': 25000000}, {'name': 'Pittsburg Alleghenys', 'team_id': 'PIT', 'max(T2.salary)': 16500000}, {'name': 'San Diego Padres', 'team_id': 'SDN', 'max(T2.salary)': 21250000}, {'name': 'Seattle Mariners', 'team_id': 'SEA', 'max(T2.salary)': 24857000}, {'name': 'San Francisco Giants', 'team_id': 'SFN', 'max(T2.salary)': 22250000}, {'name': 'St. Louis Browns', 'team_id': 'SLN', 'max(T2.salary)': 19500000}, {'name': 'Tampa Bay Devil Rays', 'team_id': 'TBA', 'max(T2.salary)': 14000000}, {'name': 'Texas Rangers', 'team_id': 'TEX', 'max(T2.salary)': 24000000}, {'name': 'Toronto Blue Jays', 'team_id': 'TOR', 'max(T2.salary)': 22000000}, {'name': 'Washington Senators', 'team_id': 'WAS', 'max(T2.salary)': 21000000}]