思路1
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;
Previous0597_Friend_Requests_I:_Overall_Acceptance_RateNext0602_Friend_Requests_II:_Who_Has_the_Most_Friends
Last updated
Was this helpful?