CREATE TABLE team (name VARCHAR, team_id VARCHAR)
CREATE TABLE salary (team_id VARCHAR, salary INT)

What are the name and id of the team offering the lowest average salary?
SELECT T1.name, T1.team_id FROM team AS T1 JOIN salary AS T2 ON T1.team_id = T2.team_id GROUP BY T1.team_id ORDER BY AVG(T2.salary) LIMIT 1
SELECT "T1"."name", "T1"."team_id" FROM "team" AS "T1" JOIN "salary" AS "T2" ON "T1"."team_id" = "T2"."team_id" GROUP BY "T1"."team_id" ORDER BY AVG("T2"."salary") NULLS FIRST LIMIT 1