1select events.minute, count(*) as nr_goals
2from @blt.ultimate_soccer_dataset.seasons s
3inner join @blt.ultimate_soccer_dataset.competitions c on (s.competition_id = c.competition_id)
4inner join @blt.ultimate_soccer_dataset.matches m on (m.season_id = s.season_id)
5inner join @blt.ultimate_soccer_dataset.match_events events on (events.match_id = m.match_id)
6where slug = 'world-cup' and s.season_label='2022' and m.status = 'Match Finished'
7      and events.event_type = 'goal'
8      and events.description not in ('Missed Penalty')
9group by all
10order by 1