What is the order 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 CUSTOMER and AGENTS tables to find the order with order number '200107' and then retrieving the order amount.",
    "query" : "SELECT o.ORD_AMOUNT FROM ORDERS o WHERE o.ORD_NUM = '200107' AND o.CUST_CODE IN (SELECT c.CUST_CODE FROM CUSTOMER c WHERE c.CUST_NAME = 'John Doe') AND o.AGENT_CODE IN (SELECT a.AGENT_CODE FROM AGENTS a WHERE a.AGENT_NAME = 'Jane Smith');",
    "operation_kind" : "list",
    "schema": "ORDERS, CUSTOMER, AGENTS",
    "confidence" : "100",
    "general_message": "Here is the order amount for the order with order number '200107'",
    "main_entity" : "order"
}