1select events.minute+coalesce(events.stoppage_time, 0) as match_minute, count(distinct m.match_id) as nr_matches
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 = 'premier-league' and year(s.start_date) >= 2015 and m.status = 'Match Finished' 
7      and events.minute <= 45
8      and events.event_type = 'goal'
9      and events.description not in ('Missed Penalty')
10group by all
11order by 1