Select and count points within a polygon

query.sql

SELECT 
  pa.*, 
  array_to_string(array_agg(cp.cartodb_id), ', ') as ids,
  count(cp.*) as count_clients
FROM
  ramirocartodb.clients_points cp  RIGHT JOIN ramirocartodb.protected_areas pa ON
  ST_Intersects(cp.the_geom, pa.the_geom)
GROUP BY
  pa.cartodb_id