Сложение строк по дате

Выполните этот запрос:

SELECT Operation, sum(ActiveTime), convert(date,Date)
FROM tab
GROUP BY Date, Operation

В качестве примера:

SELECT t1.calldate, t2.countRow, t3.total,(t3.total - t2.countRow) AS raz FROM(SELECT DATE(calldate) AS calldate
FROM cdr WHERE calldate > LAST_DAY(DATE_SUB(CURDATE(), INTERVAL 1 MONTH))
AND calldate < DATE_ADD(LAST_DAY(CURDATE()), INTERVAL 1 DAY) AND LENGTH(src)>4
AND did='73512******' AND recordingfile LIKE 'in%' GROUP BY 1) AS t1 LEFT JOIN
(SELECT DATE(calldate) AS calldate,  COUNT(DISTINCT uniqueid) AS countRow
FROM cdr WHERE calldate > LAST_DAY(DATE_SUB(CURDATE(), INTERVAL 1 MONTH))
AND calldate < DATE_ADD(LAST_DAY(CURDATE()), INTERVAL 1 DAY) AND LENGTH(src)>4
AND did='73512******' AND recordingfile LIKE 'in%' AND disposition='ANSWERED' GROUP BY 1)
AS t2 ON t1.calldate = t2.calldate LEFT JOIN(SELECT DATE(calldate) AS calldate, COUNT(DISTINCT uniqueid) AS total 
FROM cdr WHERE calldate > LAST_DAY(DATE_SUB(CURDATE(), INTERVAL 1 MONTH))
AND calldate < DATE_ADD(LAST_DAY(CURDATE()), INTERVAL 1 DAY) AND LENGTH(src)>4
AND did='7351******' AND recordingfile LIKE 'in%' GROUP BY 1) AS t3 ON t1.calldate =t3.calldate