CREATE TABLE club (Club_ID VARCHAR, name VARCHAR)
CREATE TABLE player (Points INT, Club_ID VARCHAR)

What is the average points of players from club with name 'AIB'.
SELECT AVG(T2.Points) FROM club AS T1 JOIN player AS T2 ON T1.Club_ID = T2.Club_ID WHERE T1.name = "AIB"
SELECT AVG("T2"."Points") FROM "club" AS "T1" JOIN "player" AS "T2" ON "T1"."Club_ID" = "T2"."Club_ID" WHERE "AIB" = "T1"."name"