select day(date) day, count(question_id) question_cnt from question_practice_detail group by date having date like "2021-08-%" 感觉用这个having 模糊查询就行了呀 代码简单 逻辑清晰