kate-kate/group by interval and campaign

## group by interval and campaign
SELECT FLOOR( call.created_at % ( 3600 *24 ) ) AS  `interval` , COUNT( * ) AS c, call.campaign_id, campaign.name
FROM  `call`
LEFT JOIN  `campaign` ON campaign.id = call.campaign_id
WHERE 1
GROUP BY  `interval` , campaign_id
	SELECT FLOOR( call.created_at % ( 3600 24 ) ) AS `interval` , COUNT( ) AS c, call.campaign_id, campaign.name
	FROM `call`
	LEFT JOIN `campaign` ON campaign.id = call.campaign_id
	WHERE 1
	GROUP BY `interval` , campaign_id