What are the club names and points for each player?
select t1.name,t2.points,t2.name from club as t1 join player as t2 on t1.club_id = t2.club_id
What is the average points for all of them?
select avg(t2.points) from club as t1 join player as t2 on t1.club_id = t2.club_id
What about that of the club 'BK Slide'?
select avg(t2.points) from club as t1 join player as t2 on t1.club_id = t2.club_id where t1.name = "BK Slide"
What about club 'AIB'?
select avg(t2.points) from club as t1 join player as t2 on t1.club_id = t2.club_id where t1.name = "AIB"