如何解决mysql中的统计总数据再根据当前月份的天数求平均值

Question

现在根据当前月份已经求出每天新增数据，根据当前月份的天数求平均值不知道怎么去计算了，要用sql语句解决

Answer 1

SELECT AVG(new_data) AS avg_new_data
FROM (
  SELECT COUNT(*) AS new_data
  FROM your_table
  WHERE MONTH(date_column) = MONTH(CURRENT_DATE())
  GROUP BY DAY(date_column)
) AS daily_new_data;