human
Schema:
club (Club_ID, name, Region, Start_year)
club_rank (Rank, Club_ID, Gold, Silver, Bronze, Total)
player (Player_ID, name, Position, Club_ID, Apps, Tries, Goals, Points)
competition (Competition_ID, Year, Competition_type, Country)
competition_result (Competition_ID, Club_ID_1, Club_ID_2, Score)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the club names and points for each player?
assistant
SELECT T1.name , T2.Points , T2.name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID = T2.Club_ID;
human
What is the average points for all of them?
assistant
SELECT AVG ( T2.Points ) FROM club AS T1 JOIN player AS T2 ON T1.Club_ID = T2.Club_ID;
human
What about that of the club 'BK Slide'?
assistant
SELECT AVG ( T2.Points ) FROM club AS T1 JOIN player AS T2 ON T1.Club_ID = T2.Club_ID WHERE T1.name = "BK Slide" ;