I have a table (on BigQuery) that looks like the following:
| Date | Type | Score |
|---|---|---|
| 2021-01-04 | A | 5 |
| 2021-01-04 | A | 4 |
| 2021-01-04 | A | 5 |
| 2021-01-02 | A | 1 |
| 2021-01-02 | A | 1 |
| 2021-01-01 | A | 3 |
| 2021-01-04 | B | NULL |
| 2021-01-04 | B | NULL |
| 2021-01-02 | B | NULL |
| 2021-01-02 | B | NULL |
| 2021-01-01 | B | 2 |
| 2021-01-01 | B | 5 |
| 2021-01-04 | C | NULL |
| 2021-01-04 | C | 4 |
| 2021-01-04 | C | NULL |
| 2021-01-01 | C | 1 |
| 2021-01-01 | C | 2 |
| 2021-01-01 | C | 3 |
