For Question 4, you need to get the sales by invoice month a…
For Question 4, you need to get the sales by invoice month and invoice year, sorted in ascending order by the invoice month and the invoice year. If you’re not sure how to put the query together, follow the steps below, otherwise jump to the question in the last line: 1)Can you use the same join as in the previous question? If so, proceed to the next step. If not tweak the join. 2) To get the total sales by invoice month and invoice year, you need to aggregate by those fields. You can obtain the invoice month and year by using the MONTH() and YEAR() functions on the invoice_date. Use GROUP BY on the invoice month and year and aggregate (sum) the product of price per unit and units sold. Use the alias ‘sales’ for this aggregated column. 3) Sort the output by ascending order of the invoice month and invoice year. 4) ROUND the sales to a whole number Part of the output will look similar to this (#Sales are fake though) : Question: Get the sales by invoice month and invoice year, sorted in ascending order by invoice month and year. Round the sales to whole numbers. Observe the output. Across which months did the sales show continuous increase across 2023 and 2024?