CREATE TABLE home_game (team_id VARCHAR2, year VARCHAR2, attendance NUMBER)
CREATE TABLE team (team_id VARCHAR2, rank VARCHAR2)

In 2014, what are the id and rank of the team that has the largest average number of attendance?
SELECT T2.team_id, T2.rank FROM home_game AS T1 JOIN team AS T2 ON T1.team_id = T2.team_id WHERE T1.year = 2014 GROUP BY T1.team_id ORDER BY AVG(T1.attendance) DESC LIMIT 1
SELECT "T2"."team_id", "T2"."rank" FROM "home_game" "T1" JOIN "team" "T2" ON "T1"."team_id" = "T2"."team_id" WHERE "T1"."year" = 2014 GROUP BY "T1"."team_id" ORDER BY AVG("T1"."attendance") DESC FETCH FIRST 1 ROWS ONLY