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"
average points of players = AVG(player.Points); from club with name \"AIB\" refers to WHERE club.name = \"AIB\"; JOIN is used to link club and player tables based on their relationship through Club_ID.