select date, round(sum(type = "no_completed") / count(*), 3) as p from email where send_id in (select id from user where is_blacklist = 0) and receive_id in (select id from user where is_blacklist = 0) group by date order by date
点赞

相关推荐

牛客37185681...:马德,我感觉这是我面过最恶心的公司,一面是两个女hr,说什么实习前几个月属于试用期,试用期过了才能转成正式实习生,我***笑了,问待遇就是不说,问能不能接受全栈,沙币公司
如果可以选,你最想去哪家...
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务