File size: 456 Bytes
29a6f70 |
1 2 3 4 5 6 7 8 |
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
|