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
how many stadium are presented on the table
assistant
SELECT COUNT( * ) FROM stadium;
human
list out the stadium names
assistant
SELECT name FROM stadium;
human
what is the average attendance of Cowboys Stadium
assistant
SELECT Average_Attendance FROM stadium WHERE name = 'Cowboys Stadium';
human
what is the capacity percentage of FedExField
assistant
SELECT Capacity_Percentage FROM stadium WHERE name = "FedExField" ;