image.png

    解题思路

    1. select round(
    2. ifnull(
    3. (select count(distinct requester_id ,accepter_id) from RequestAccepted ) /
    4. (select count(distinct sender_id ,send_to_id) from FriendRequest )
    5. ,0)
    6. ,2) as accept_rate