Friend Request Acceptance Rate
Start Timer
0:00:00
A social media company re-designed its UI to include notifications to users when they receive friend requests.
Evaluate if this change increased the friend request acceptance rate. Find the acceptance rate for friend requests sent in the four weeks prior to (and including) July 2nd, 2022.
Note: The acceptance rate is the percentage of sent requests that were accepted.*
Assume that nobody sends or accepts the same request twice. We will consider two friend requests to be duplicates when their sender and receiver are the same.
Example
Input:
friend_requests
| Column | Type |
|---|---|
| requester_id | INTEGER |
| receiver_id | INTEGER |
| sent_at | DATETIME |
requests_accepted
| Column | Type |
|---|---|
| accepter_id | INTEGER |
| requester_id | INTEGER |
| accepted_at | DATETIME |
Output:
| Column | Type |
|---|---|
| acceptance_rate | FLOAT |
.
.
.
.
.
.
.
.
.
Comments