题解 | #统计作答次数#

统计作答次数

https://www.nowcoder.com/practice/45a87639110841b6950ef6a12d20175f

select sum(if(start_time is not null,1,0)) total_pv,
sum(if(submit_time is not null,1,0))complete_pv,
count(distinct (if(score is not null,1,0 ))) complete_exam_cnt
from exam_record

全部评论

相关推荐

暮雨轻歌:看起来hr不能接受我菜查看图片
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客企业服务