1SELECT 
2  m.date::date as "Match Date",
3  m.competition_name as "Competition",
4  s.season_label as "Season",
5  home_team_name as "Home Team",
6  away_team_name as "Away Team",
7  o.market,
8  o.outcome,
9  round(avg(o.odds),1) as average_odds
10FROM @blt.ultimate_soccer_dataset.matches m
11LEFT OUTER JOIN "@blt.ultimate_soccer_dataset.seasons" s 
12  ON m.season_id = s.season_id
13LEFT OUTER JOIN "@blt.ultimate_soccer_dataset.competitions" c 
14  ON s.competition_id = c.competition_id
15INNER JOIN "@blt.ultimate_soccer_dataset.match_betting_odds" o
16  ON m.match_id = o.match_id
17WHERE status = 'Not Started' AND m.date >= NOW()
18      AND c.slug = 'premier-league' and s.season_label = '2025/2026'  and c.country = 'England'
19GROUP BY m.date, m.competition_name, s.season_label, m.home_team_name, m.away_team_name, o.market, o.outcome
20ORDER BY m.date ASC, m.competition_name, home_team_name, away_team_name, o.market, o.outcome
21LIMIT 200