hard
Complex SQL Construction
Write a SQL query to filter and aggregate data.
📝 Contenu du Prompt
Write a SQL query for a table named 'orders' that selects the customer_id and the total amount spent for customers who have placed more than three orders in the year 2023. Order the results by the total amount spent in descending order.