Create friend-requests-i-overall-acceptance-rate.sql

kamyu104 · web-flow · commit f6595ca67f4a · 2017-11-10T07:24:54.000-06:00
diff --git a/MySQL/friend-requests-i-overall-acceptance-rate.sql b/MySQL/friend-requests-i-overall-acceptance-rate.sql
@@ -0,0 +1,11 @@
+# Time:  O(rlogr + aloga)
+# Space: O(r + a)
+
+SELECT
+ROUND(
+    IFNULL(
+    (SELECT COUNT(*) FROM (SELECT DISTINCT requester_id, accepter_id FROM request_accepted) AS r)
+    /
+    (SELECT COUNT(*) FROM (SELECT DISTINCT sender_id, send_to_id FROM friend_request) AS a),
+    0)
+, 2) AS accept_rate;
