Mine

SELECT year(calldate) as year,month(calldate) as month ,day(calldate) as day, dst, count (dst), sum(billsec) FROM `cdr` where dcontext="from-E1" group by year(calldate), month(calldate), day(calldate), dst order by year(calldate), month(calldate), day(calldate), dst