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 game ids of all the injury accidents.
assistant
SELECT game_id FROM injury_accident;
human
Which stadium did each of them happen?
assistant
SELECT T2.name , T3.game_id FROM game AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.id JOIN injury_accident AS T3 ON T1.id = T3.game_id GROUP by T3.game_id;
human
Show me the name of stadiums which are not one of those.
assistant
SELECT name FROM stadium EXCEPT SELECT T2.name FROM game AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.id JOIN injury_accident AS T3 ON T1.id = T3.game_id GROUP by T3.game_id ;