Sobes.tech
Senior

Write an SQL query that outputs the **client's name**, their **city**, and **total amount** of all their orders. The final selection should include only those clients whose total expenses exceed **1000** units. --- **Data schema:** 1. **`customers` table:** - `customer_id` (int) – unique customer identifier. - `customer_name` (varchar) – customer's name. - `city` (varchar) – city of residence. 2. **`orders` table:** - `order_id` (int) – unique order number. - `customer_id` (int) – ID of the customer who made the purchase. - `total_amount` (decimal) – amount of the specific order.