Find the order with the highest order amount.
{
    "explanation": "I finalized the SQL query by analyzing the schema and context provided. The question asks for the order with the highest order amount. I used the ORDER BY clause to sort the orders by the order amount in descending order and then used the LIMIT clause to retrieve only the first row. I also used the CUSTOMER and ORDERS tables to filter the orders and retrieve the highest order amount.",
    "query" : "SELECT o.ORD_NUM, o.ORD_AMOUNT, o.ADVANCE_AMOUNT, o.ORD_DATE, c.CUST_CODE, c.CUST_NAME, c.CUST_CITY, c.WORKING_AREA, c.CUST_COUNTRY, c.GRADE, c.OPENING_AMT, c.RECEIVE_AMT, c.PAYMENT_AMT, c.OUTSTANDING_AMT, c.PHONE_NO, a.AGENT_CODE, o.ORD_DESCRIPTION FROM ORDERS o JOIN CUSTOMER c ON o.CUST_CODE = c.CUST_CODE JOIN AGENTS a ON o.AGENT_CODE = a.AGENT_CODE WHERE o.ORD_AMOUNT = (SELECT MAX(o2.ORD_AMOUNT) FROM ORDERS o2) ORDER BY o.ORD_AMOUNT DESC LIMIT 1;",
    "operation_kind" : "aggregation",
    "schema": "ORDERS, CUSTOMER, AGENTS",
    "confidence" : "100",
    "general_message": "Here is the order with the highest order amount",
    "main_entity" : "order"
}