LeetCode-597. 好友申请 I ：总体通过率（简单）

题目来源：力扣（LeetCode）
链接：https://leetcode-cn.com/problems/friend-requests-i-overall-acceptance-rate
著作权归领扣网络所有。商业转载请联系官方授权，非商业转载请注明出处。

本人思路：
1、题意很清晰，注意select后面的搜索列的写法

-- 写法一
select 
round (ifnull(
        (select count(distinct concat(requester_id,accepter_id))from request_accepted)
        /
        (select count(distinct concat(sender_id,send_to_id) )from friend_request),
        0)
,2)as accept_rate;

-- 写法二
select
round(
    ifnull(
    (select count(*) from (select distinct requester_id, accepter_id from request_accepted) as A)
    /
    (select count(*) from (select distinct sender_id, send_to_id from friend_request) as B),
    0)
, 2) as accept_rate;