题解 | 21年8月份练题总数
21年8月份练题总数
https://www.nowcoder.com/practice/b8f30b239b454ed490367b53ea95607d
SELECT COUNT(distinct device_id),COUNT(question_id) FROM question_practice_detail WHERE date_format(date, '%Y-%m')='2021-08'
SELECT COUNT(distinct device_id),COUNT(question_id) FROM question_practice_detail WHERE date like '2021-08-%'
SELECT COUNT(distinct device_id),COUNT(question_id) FROM question_practice_detail WHERE year(date)='2021' AND month(date)='08'
