hard
Generate Revenue SQL Query
Write a complex SQL query to analyze top spending customers.
📝 プロンプトの内容
Write a SQL query for a PostgreSQL database that has a 'users' table and an 'orders' table. The query should return the top 10 users by total spending in the last 30 days, displaying their user ID, name, and total amount spent.