Distinct 可以筛选多个 column

Distinct 可以筛选多个 column【597. 好友申请Ⅰ:总体通过率】

select round(
    ifnull(
    (select count(distinct requester_id ,accepter_id) from request_accepted) / 
    (select count(distinct sender_id ,send_to_id) from friend_request)
    ,0)
    ,2) as accept_rate ;
posted @ 2023-12-26 20:14  爱新觉罗LQ  阅读(12)  评论(0)    收藏  举报