1 2 3 4 5
| WITH all_pc as (SELECT public.env_point_collecte.commune as commune_all FROM public.env_point_collecte WHERE public.env_point_collecte.commune <> '' GROUP BY public.env_point_collecte.commune)
SELECT COUNT(*) as data , all_pc.commune_all as legend
FROM all_pc LEFT JOIN public.env_point_collecte ON all_pc.commune_all = env_point_collecte.commune
WHERE public.env_point_collecte.type_flux = 'Collecte sélective '
GROUP BY all_pc.commune_all,env_point_collecte.commune ORDER BY all_pc.commune_all ASC |