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.