Someone
public text v1 · immutableSELECT
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