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