SELECT atlas_polygon.name, points.class, SUM(points.number) AS number, COUNT(points.class) AS location, atlas_polygon.geometry
FROM points
INNER JOIN
atlas_polygon
ON
st_intersects(points.geometry, atlas_polygon.geometry)
GROUP BY atlas_polygon.name, points.class