CREATE TABLE team (name VARCHAR2, team_id VARCHAR2)
CREATE TABLE salary (salary NUMBER, team_id VARCHAR2)

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" "T1" JOIN "salary" "T2" ON "T1"."team_id" = "T2"."team_id" GROUP BY "T1"."team_id"