human
Schema:
stadium (id, name, Home_Games, Average_Attendance, Total_Attendance, Capacity_Percentage)
game (stadium_id, id, Season, Date, Home_team, Away_team, Score, Competition)
injury_accident (game_id, id, Player, Injury, Number_of_matches, Source)
Please answer with SQL.
assistant
Sure, I understand.
human
what are all games are presented on the table | What kind of infromation for the games do you want ? | i want to how many teams on the game
assistant
SELECT COUNT( distinct home_team ) FROM game;
human
which player are played in highest number of matches
assistant
SELECT Player FROM injury_accident ORDER by Number_of_matches desc LIMIT 1 ;