medium
SQL Sales Report Query
Write an SQL query to calculate total sales grouped by category.
📝 Prompt Content
Write an SQL query for a table named 'sales' with columns 'id', 'product_category', and 'amount'. The query should return the total sales amount for each product category, ordered by the total amount in descending order.