1SELECT
2 date::date as "Match Date",
3 (home_score + away_score) as "Total Goals",
4 home_team_name as "Home Team",
5 away_team_name as "Away Team",
6 home_score as "Home Score",
7 away_score as "Away Score",
8 venue_name as "Venue"
9FROM @blt.ultimate_soccer_dataset.matches m
10LEFT OUTER JOIN "@blt.ultimate_soccer_dataset.seasons" s
11 ON m.season_id = s.season_id
12LEFT OUTER JOIN "@blt.ultimate_soccer_dataset.competitions" c
13 ON s.competition_id = c.competition_id
14WHERE status = 'Match Finished' and c.slug = 'world-cup' and s.season_label = '2026'
15ORDER BY date DESC, m.competition_name
16LIMIT 500