1SELECT
2  ge.team_name as "Team",
3  COUNT(*) AS "Goals"
4FROM
5  "@blt.ultimate_soccer_dataset.goal_events" ge
6  JOIN "@blt.ultimate_soccer_dataset.matches" m ON ge.match_id = m.match_id
7WHERE
8  m.competition_name = 'World Cup'
9  AND m.season_year = 2022
10  -- AND ge.goal_type != 'Own Goal'
11  AND (
12    ge.notes IS NULL
13    OR ge.notes != 'Penalty Shootout'
14  )
15GROUP BY
16  ge.team_name
17ORDER BY
18  "Goals" DESC