<p>We’re given two tables. <code>friend_requests</code> holds all the friend requests made and <code>friend_accepts</code> is all of the acceptances.</p>

<p>Write a query to find the overall acceptance rate of friend requests.</p>

<p><em>Note: Round results to 4 decimal places.</em></p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>friend_requests</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>requester_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>requested_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><code>friend_accepts</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>acceptor_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>requester_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>acceptance_rate</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Acceptance Rate

Comments