SQL39题解 | #21年8月份练题总数#
21年8月份练题总数
https://www.nowcoder.com/practice/b8f30b239b454ed490367b53ea95607d
#练习总题数: COUNT(questiono_id)
#八月份练习总题数:SUM( IF( YEAR(date)=21 AND MONTH(DATE) = 8, 1 ,0))
SELECT COUNT(DISTINCT device_id) AS did_cnt,
COUNT(question_id) AS question_cnt
FROM question_practice_detail
WHERE date like '2021-08%';
#SQL练习#SQL专项练习 文章被收录于专栏
SQL语句
