题解 | #异常的邮件概率#

异常的邮件概率

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

select
    date,
    round(
        sum(
            case
                type
                when 'completed' then 0
                else 1
            end
        ) / count(type),
        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
    email.date
order by
    date asc

全部评论

相关推荐

03-02 10:51
邵阳学院 Java
红鲤鱼与绿鲤鱼i:看了你的头像不像找工作,像在找妹子
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客企业服务