sql - Average on the most recent date for which data is available

Question

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

Answer 1

Waitting for answers