All pastes #93497 Raw Edit

Someone

public text v1 · immutable
#93497 ·published 2006-07-20 14:34 UTC
rendered paste body
SELECT
      DATE_FORMAT(MIN(calls.`datetime`), '%Y/%m/01') as `Period`,
      campaigns.alias as `Campaign`,
      COUNT(*) as `Response`

FROM calls

JOIN campaigns ON calls.campaign_id=campaigns.id

GROUP BY DATE_FORMAT(`datetime`, '%Y/%m/01'), calls.campaign_id

ORDER BY DATE_FORMAT(`datetime`, '%Y/%m/01') DESC