SELECT avg(montreal_postgis.rev)::Integer AS avg_rev, quartier_socio.q_socio, quartier_socio.geom FROM montreal_postgis JOIN quartier_socio ON ST_Intersects(montreal_postgis.geom, quartier_socio.geom) GROUP BY quartier_socio.q_socio, quartier_socio.geom Order By avg_rev desc;