Compte le nombre d'export par expression cron

SELECT 
    COUNT(*) as total,
    frequency::cron
FROM organization_reporting 
WHERE 
  (expired_at IS NULL OR expired_at > now())
  AND organization_reporting.deleted_at IS NULL
GROUP BY frequency::cron
ORDER BY total DESC;

Keywords

organization_reporting count cron