Mine

SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() - INTERVAL 7 DAY <= calldate
	AND calldate < NOW() + INTERVAL 1 DAY
GROUP BY DATE(calldate)
ORDER BY calldate DESC;