Average number of rows created per day?

This will return an int number:

select count(*) / count(distinct date(created_at))
from your_table

To get a decimal number use:

select count(*) * 1.0 / count(distinct date(created_at))
from your_table

SELECT AVG(rowsPerDay) AS avgPerDay
FROM ( SELECT 
         COUNT(*) AS rowsPerDay
       FROM tbl
       GROUP BY DATE(created_at)
     ) AS a
;

Related