1SELECT
2 m.date,
3 m.home_team_name,
4 m.away_team_name,
5 m.home_score,
6 m.away_score,
7 m.status,
8 CAST(m.date AS DATE) AS match_date
9FROM
10 "@blt.ultimate_soccer_dataset.matches" m
11WHERE
12 m.competition_name = 'Premier League'
13 AND m.status = 'Not Started'
14 AND CAST(m.date AS DATE) < CAST('2025-11-26' AS DATE)
15ORDER BY
16 m.date DESC