intermediate
Generate SQL Aggregation Query
Write a SQL query to calculate total sales per region.
📝 프롬프트 내용
Write a SQL query for a table named 'sales' with columns 'id', 'amount', 'region', and 'date'. The query should return the total sales amount for each region where the date is in the current year. Order the results by the total amount in descending order.