database_schema: "\nCREATE TABLE res_partner (\n id INTEGER PRIMARY KEY, \n \ \ name VARCHAR(255),\n email VARCHAR(255),\n phone VARCHAR(64)\n);\nCREATE\ \ TABLE sale_order (\n id INTEGER PRIMARY KEY,\n partner_id INTEGER REFERENCES\ \ res_partner(id),\n date_order TIMESTAMP,\n state VARCHAR(20),\n amount_total\ \ NUMERIC\n);\n" query_question: Find all customers who have orders with a total amount greater than 1000