1SELECT
2  COUNT(*) AS "Goals"
3FROM
4  "@blt.ultimate_soccer_dataset.goal_events" ge
5  JOIN "@blt.ultimate_soccer_dataset.matches" m ON ge.match_id = m.match_id
6WHERE
7  m.competition_name = 'World Cup'
8  AND m.season_year = 2022
9  AND (
10    ge.notes IS NULL
11    OR ge.notes != 'Penalty Shootout'
12  )