<p>Given a table of transactions and a table of users, write a query to determine if users tend to order more to their primary address versus other addresses.</p>

<p><em>Note: Return the percentage of transactions ordered to their home address as <code>home_address_percent</code>.</em></p>

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

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

<p><code>transactions</code> table:</p>

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

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

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>shipping_address</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><code>users</code> table:</p>

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

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

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>address</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Example Output:</strong></p>

<table>
<thead>
<tr>
<th><code>home_address_percent</code></th>
<th>0.76</th>
</tr>
</thead>

<tbody>
</tbody>
</table>


Order Addresses

Comments