What are the ids, scores, and dates of the games which caused at most two injury accidents?
select t1.id, t1.score, t1.date from game as t1 join injury_accident as t2 on t2.game_id = t1.id group by t1.id having count ( * ) < = 2
Yes.
select count ( distinct competition ) from game
How many number of different home teams?
select count ( distinct home_team ) from game