题解 | #月总刷题数和日均刷题数#

月总刷题数和日均刷题数

https://www.nowcoder.com/practice/f6b4770f453d4163acc419e3d19e6746

select date_format(submit_time,'%Y%m') as submit_month,
any_value(count(submit_time)) as month_q_cnt,
any_value(round(count(submit_time)/day(last_day(submit_time)),3)) as avg_day_q_cnt
from practice_record
where year(submit_time)=2021
group by date_format(submit_time,'%Y%m')

union all

select '2021汇总' as submit_month , any_value(count(submit_time)) as month_q_cnt,any_value(round(count(submit_time)/31,3)) as avg_day_q_cnt
from practice_record where score is not null
and year(submit_time)=2021

order by submit_month

求一个月有多少天:day(last_day())

select检索group by list 之外的列需要加 any_value()

全部评论

相关推荐

一表renzha:手写数字识别就是一个作业而已
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务