select
c.geoid
, cast(avg(z.aland10) as decimal(10,2))
from denver.zip_codes as z
join denver.county as c on ST_Intersects(ST_Centroid(z.geom), c.geom)
group by c.geoid