LeetCode - SQL 597 -两个group bys 代替 distinct

题目：

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

Table: friend_request

sender_id	send_to_id	request_date
1	2	2016_06-01
1	3	2016_06-01
1	4	2016_06-01
2	3	2016_06-02
3	4	2016-06-09

Table: request_accepted

requester_id	accepter_id	accept_date
1	2	2016_06-03
1	3	2016-06-08
2	3	2016-06-08
3	4	2016-06-09
3	4	2016-06-10

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.

accept_rate
0.80

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.

Follow-up:
Can you write a query to return the accept rate but for every month?
How about the cumulative accept rate for every day?

思路：

accp_rate = total unique sent requests / total unique accepted requests

因为

-- total unique sent requests
    select count(sender_id) as tot_req from(
    select sender_id
    from friend_request
    group by sender_id, send_to_id) as t1 # 通过sender_id 和send_to_id 合并来确定该记录是unique

# 同时也可以同时用distinct 两个来操作
SELECT COUNT(DISTINCT requester_id,accepter_id) FROM request_accepted

-- total unique accepted requests
    select count(requester_id) as tot_act from  (
    select requester_id
    from request_accepted
    group by requester_id, accepter_id) as t2