<p>The analytics team at a social media platform wants to analyze the short-term trends in daily user growth. For this task, they want you to calculate the 3-day rolling weighted average for new daily users, where the current day has a weight of 3, the previous day has a weight of 2, and the day before has a weight of 1.</p>

<p>The platform logs new records into the <code>acquisitions</code> table for the days on which new users arrive. Otherwise, it skips the date.</p>

<p>Write a SQL query to calculate the 3-day rolling weighted average for new daily users from the <strong><code>acquisitions</code></strong> table.</p>

<p>Round the average to two decimal places.</p>

<h3>Example:</h3>

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

<p><code>acquisitions</code> table</p>

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

<tbody>
<tr>
<td>date</td>
<td>DATE</td>
</tr>

<tr>
<td>new_users</td>
<td>DECIMAL</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td>date</td>
<td>DATE</td>
</tr>

<tr>
<td>weighted_average</td>
<td>DECIMAL</td>
</tr>
</tbody>
</table>


Write a SQL query to calculate the 3-day rolling weighted average for new daily users.

Weighted Average With Missing Dates

Comments