SQL. Average entries per month

try this out

SELECT COUNT(*)/COUNT(DISTINCT MONTH(`datefield`)) FROM tablename

No subqueries

SELECT count(*) AS count, MONTH(date_column) as mnth
FROM table_name
GROUP BY mnth

Should work for you

Edit:

SELECT AVG(a.count) AS avg 
FROM ( SELECT count(*) AS count, MONTH(date_column) as mnth
       FROM table_name
       GROUP BY mnth) AS a

Related