Intermediate
SQL Query for Monthly Sales
Generate a SQL query to aggregate sales data by month.
📝 プロンプトの内容
Write a SQL query for a table named 'sales' with columns 'id', 'amount', and 'transaction_date'. The query should calculate the total sales amount for each month and order the results by the most recent month first.