Intermediate
Write SQL Sales Aggregation
Construct a SQL query to calculate total sales per region.
📝 Prompt-Inhalt
Write a SQL query for a table named 'sales' which has columns 'id', 'product_name', 'region', 'amount', and 'sale_date'. The query should calculate the total sales amount for each region. Only include sales that occurred in the current year. Order the results by the total sales amount in descending order.