题目:作为牛客网的数据分析师,现在运营想要计算出2021年8月每天用户练习题目的数量,请取出相应数据。
Select day(date) as day, count(question_id) as question_cnt
From question_practice_detail
Where year(date)=2021 and month(date)=08
Group by day
题目:作为牛客网的数据分析师,现在运营想要计算出2021年8月每天用户练习题目的数量,请取出相应数据。
Select day(date) as day, count(question_id) as question_cnt
From question_practice_detail
Where year(date)=2021 and month(date)=08
Group by day