By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| id | EventName | HomeTeam | Metric | PreviousMetric1 | PreviousMetric2 |
|---|---|---|---|---|---|
| 1 | Team A vs Team B | Team A | 5 | null | null |
| 2 | Team A vs Team B | Team A | 7 | 5 | null |
| 3 | Team C vs Team D | Team C | 6 | null | null |
| 4 | Team Z vs Team A | Team Z | 8 | null | null |
| 5 | Team A vs Team B | Team A | 9 | 8 | 7 |
| 6 | Team C vs Team D | Team C | 3 | 6 | null |
| 7 | Team C vs Team D | Team C | 1 | 3 | 6 |
| 8 | Team E vs Team F | Team E | 2 | null | null |