human
Schema:
player (Player_ID, Sponsor_name, Player_name, Gender, Residence, Occupation, Votes, Rank)
club (Club_ID, Club_name, Region, Start_year)
coach (Coach_ID, Coach_name, Gender, Club_ID, Rank)
player_coach (Player_ID, Coach_ID, Starting_year)
match_result (Rank, Club_ID, Gold, Big_Silver, Small_Silver, Bronze, Points)
Please answer with SQL.
assistant
Sure, I understand.
human
How many clubs are there?
assistant
SELECT COUNT( club_id ) FROM club;
human
How many coaches in total?
assistant
SELECT COUNT( * ) FROM coach;
human
How many coaches are there from 'AIK' club?
assistant
SELECT COUNT( * ) FROM coach AS T1 JOIN club AS T2 ON T1.club_id = T2.club_id WHERE T2.club_name = "AIK" ;