| 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 | |