What is the advance amount for the order with order number '200107' in the ORDERS table?
{
    "explanation": "I finalized the SQL query by joining the ORDERS table with the AGENTS table to get the advance amount for the order with order number '200107'. I used the AGENT_CODE column in the CUSTOMER table to reference the AGENTS table.",
    "query" : "SELECT O.ORD_AMOUNT, A.AGENT_NAME, O.ORD_NUM FROM ORDERS O JOIN AGENTS A ON O.AGENT_CODE = A.AGENT_CODE WHERE O.ORD_NUM = '200107'",
    "operation_kind" : "list",
    "schema": "ORDERS, AGENTS",
    "confidence" : "100",
    "general_message": "Here is the advance amount for the order with order number '200107'",
    "main_entity" : "order"
}