By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Region | City | MinDate | MaxDate | AvgFiltered | AvgAll |
---|---|---|---|---|---|
NE | Boston | 2021-10-03 | 2021-10-04 | 27.500000 | 185.000000 |
SW | Phoenix | 2021-10-01 | 2021-10-04 | 308.333333 | 348.000000 |
Warning: Null value is eliminated by an aggregate or other SET operation.