Calculate the average total invoice amount and specifically calculate the average total of invoices from the year 2020.
<ul>
<li>Columns to Retrieve:
<ul>
<li><code data-prestyled="true" class="rounded dark:bg-gray-800 dark:text-white text-black bg-gray-100 px-[0.25rem] py-[0.1rem] text-sm font-normal font-mono">AverageTotal</code></li>
<li><code data-prestyled="true" class="rounded dark:bg-gray-800 dark:text-white text-black bg-gray-100 px-[0.25rem] py-[0.1rem] text-sm font-normal font-mono">AverageTotal2020</code></li>
</ul>
</li>
<li>Details:
<ul>
<li>You need to form a query targeting the Invoice table.</li>
<li>You are required to calculate the average total invoice amount across all records.</li>
<li>Additionally, an average of the total invoice amounts specifically for the year 2020 should also be calculated.</li>
</ul>
</li>
<li>Ordering Requirement:
<ul>
<li>The results should be ordered by <code data-prestyled="true" class="rounded dark:bg-gray-800 dark:text-white text-black bg-gray-100 px-[0.25rem] py-[0.1rem] text-sm font-normal font-mono">AverageTotal</code>.</li>
</ul>
</li>
</ul>

Filtered Aggregates