medium
Write a SQL Query
Construct a SQL statement to retrieve specific data from two tables.
📝 Prompt Content
Write a SQL query to select all customer names and their total order amounts from a 'customers' table and an 'orders' table, joining them by customer ID, where the total amount is greater than 1000.