CREATE TABLE player (Points INTEGER, Club_ID VARCHAR(255)); CREATE TABLE club (Club_ID VARCHAR(255), name VARCHAR(255))
What is the average points of players from club with name "AIB".
    
SQL: SELECT AVG(T2.Points) FROM club AS T1 JOIN player AS T2 ON T1.Club_ID = T2.Club_ID WHERE T1.name = "AIB"