Easy no subquery AC solution


  • 1
    select 
    ifnull((select round(count(distinct requester_id,accepter_id)/count(distinct sender_id, send_to_id),2)
    from request_accepted, friend_request),0)
    as accept_rate

Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.