This Leetcode problem Friend Requests I Overall Acceptance Rate LeetCode Solution is done in SQL.

List of all LeetCode Solution

Friend Requests I Overall Acceptance Rate LeetCode Solution

Problem Statement

In social network like Facebook or Twitter, people send friend requests and accept others’ requests as well. Now given two tables as below:

Write a query to find the overall acceptance rate of requests rounded to 2 decimals, which is the number of acceptance divide the number of requests.

For the sample data above, your query should return the following result.

Note: The accepted requests are not necessarily from the table friend_request. In this case, you just need to simply count the total accepted requests (no matter whether they are in the original requests), and divide it by the number of requests to get the acceptance rate.
It is possible that a sender sends multiple requests to the same receiver, and a request could be accepted more than once. In this case, the ‘duplicated’ requests or acceptances are only counted once.
If there is no requests at all, you should return 0.00 as the accept_rate.

Explanation: There are 4 unique accepted requests, and there are 5 requests in
total. So the rate is 0.80.

Friend Requests I Overall Acceptance Rate LeetCode Solution MySQL

select 
  round(
    if(requests = 0, 0, accepts / requests), 
    2
  ) as accept_rate 
from 
  (
    select 
      count(distinct sender_id, send_to_id) as requests 
    from 
      friend_request
  ) as r, 
  (
    select 
      count(
        distinct requester_id, accepter_id
      ) as accepts 
    from 
      request_accepted
  ) as a;Code language: SQL (Structured Query Language) (sql)