CREATE TABLE club (Club_ID VARCHAR2, name VARCHAR2)
CREATE TABLE player (Points NUMBER, Club_ID VARCHAR2)

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" "T1" JOIN "player" "T2" ON "T1"."Club_ID" = "T2"."Club_ID" WHERE "AIB" = "T1"."name"