1SELECT
2  kickoff_date_utc,
3  competition_name,
4  home_team_name,
5  away_team_name,
6  home_score,
7  away_score,
8  CASE
9    WHEN home_team_name = 'Paris Saint Germain'
10    AND home_score > away_score THEN 'Win'
11    WHEN away_team_name = 'Paris Saint Germain'
12    AND away_score > home_score THEN 'Win'
13    WHEN home_score = away_score THEN 'Draw'
14    WHEN home_team_name = 'Paris Saint Germain'
15    AND home_score < away_score THEN 'Loss'
16    WHEN away_team_name = 'Paris Saint Germain'
17    AND away_score < home_score THEN 'Loss'
18  END AS result
19FROM
20  "@blt.ultimate_soccer_dataset.matches"
21WHERE
22  (
23    home_team_name = 'Paris Saint Germain'
24    OR away_team_name = 'Paris Saint Germain'
25  )
26  AND kickoff_date_utc > '2025-05-31'
27  AND status = 'Match Finished'
28ORDER BY
29  kickoff_date_utc ASC