select count(distinct device_id) as did_cnt, count(question_id) as question_cut from question_practice_detail where date like '2021-08%'
group by添加在聚合函数后面,日期还可以用like‘’表示。只写了月份要08,怪不得答案不对哈哈哈哈哈