MySQLで日毎に集計を行う

SELECT
    DATE_FORMAT(created_at, '%Y-%m-%d') as created_at,
    COUNT(*) as count
FROM
    log_table
GROUP BY
    DATE_FORMAT(created_at, '%Y%m%d');