ERREUR : pas de CP
SELECT PAYS,REGION,VILLE,CODEPOSTAL, count(*) as nb FROM view_poi where CODEPOSTAL='7502' GROUP BY PAYS,REGION,VILLE,CODEPOSTAL ORDER BY nb DESC