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;