medium
Generate SQL Aggregation Query
Write a SQL query to calculate total sales per region.
📝 Contenu du Prompt
Write a SQL query for a table named 'sales' with columns 'id', 'product_name', 'amount', and 'region'. The query should return the total sales amount for each region, ordered by the total amount in descending order.