PostGIS count, sum, average value per aggreazioni GROUP >> SELECT PROVINCIA, count(*),
sum(st_area(st_transform(st_setsrid(SP_GEOMETRY,4326),32632))),
avg(st_area(st_transform(st_setsrid(SP_GEOMETRY,4326),32632)))
FROM public.Comuni_MapInfo
GROUP BY PROVINCIA