SELECT count(*) AS count, MONTH(date_column) as mnth
FROM table_name
GROUP BY mnth
应该为你工作
编辑:
SELECT AVG(a.count) AS avg
FROM ( SELECT count(*) AS count, MONTH(date_column) as mnth
FROM table_name
GROUP BY mnth) AS a
SQL。每月平均条目
SELECT count(*) AS count, MONTH(date_column) as mnth
FROM table_name
GROUP BY mnth
应该为你工作
编辑:
SELECT AVG(a.count) AS avg
FROM ( SELECT count(*) AS count, MONTH(date_column) as mnth
FROM table_name
GROUP BY mnth) AS a