SELECT DISTINCT DAY(qpd.date) AS day ,COUNT(DAY(qpd.date)) AS question_cnt
FROM question_practice_detail qpd
WHERE MONTH(date)=8
GROUP BY day;
#主要得分组
SELECT DISTINCT DAY(qpd.date) AS day ,COUNT(DAY(qpd.date)) AS question_cnt
FROM question_practice_detail qpd
WHERE MONTH(date)=8
GROUP BY day;
#主要得分组
牛客博客，记录你的成长
京公网安备 11010502036488号