1select count(*) as total_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)
5where slug = 'world-cup' and season_label = '2022' and m.status = 'Match Finished'
6