fuck fuck off

 SELECT yyyy,mon,dd,count(*) FROM (
        SELECT
      extract(day from (created_at AT TIME ZONE 'UTC' AT TIME ZONE 'ART')::timestamp ) as dd,
            extract(month from (created_at AT TIME ZONE 'UTC' AT TIME ZONE 'ART')::timestamp ) as mon,
            extract(year from (created_at AT TIME ZONE 'UTC' AT TIME ZONE 'ART')::timestamp ) as yyyy
        FROM leads
        WHERE platform = 'web'
        AND (created_at AT TIME ZONE 'UTC' AT TIME ZONE 'ART')::timestamp >= '2017-04-11'
        GROUP BY 1,2,3,email,discount_id
      ) AS t GROUP BY dd,mon,yyyy
      ORDER BY yyyy,mon,dd