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.status = 'Not Started'
13  AND CAST(m.date AS DATE) < CAST('2025-11-27' AS DATE)
14ORDER BY
15  m.date DESC