Sobes.tech
Senior

You have two tables: orders (orders): order_id (unique order identifier) customer_id (customer identifier) order_date (order date) total_amount (total amount of the order) customers (customers): customer_id (customer identifier) customer_name (name of the customer) city (city of the customer) Task: Write an SQL query that returns the following data: List of customers (name and city) who have placed orders with a total amount greater than 1000 dollars. For each customer from point 1, display the total sum of all orders.