SELECT count(*) AS "count", CAST("public"."res_partner"."create_date" AS date) AS "create_date"
FROM "public"."res_partner"
WHERE ("public"."res_partner"."barcode" IS NOT NULL
   AND "public"."res_partner"."active" = TRUE)
GROUP BY CAST("public"."res_partner"."create_date" AS date)
ORDER BY CAST("public"."res_partner"."create_date" AS date) ASC