题目思路
求的是用户数 和题目数
用户存在多个重复 需要去重 题目数不变 不需要去重
用month 函数找出八月份
代码实现
select count(distinct device_id) did_cnt , count(question_id) question_cnt from question_practice_detail where month(date)=8
select count(distinct device_id) did_cnt , count(question_id) question_cnt from question_practice_detail where month(date)=8