How to display average values in a row in place of null in bigquery?

Row	urban_pop	med_age	migrants	fert_rate	landarea
1	null	null	null	null	570
2	null	null	null	null	640
3	23	30	35	13	450

I need to replace average values in place of null values in respective columns.

thank you

https://stackoverflow.com/questions/66020871/how-to-display-average-values-in-a-row-in-place-of-null-in-bigquery February 03, 2021 at 11:33AM