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
Show me the names of all the stadiums.
assistant
SELECT name FROM Stadium;
human
How many home games did each of them hold?
assistant
SELECT name , home_games FROM Stadium;
human
Show me the maxium, minimum, and average of them.
assistant
SELECT MAX( home_games ) , MIN( home_games ) , AVG ( home_games ) FROM stadium ;