What is the order description for the order with order number '200110' 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 '200110' and then retrieving the order description.",
    "query" : "SELECT o.ORD_DESCRIPTION FROM ORDERS o WHERE o.ORD_NUM = '200110' AND o.CUST_CODE IN (SELECT c.CUST_CODE FROM CUSTOMER c WHERE c.CUST_CITY = 'New York' AND c.CUST_COUNTRY = 'USA') AND o.AGENT_CODE IN (SELECT a.AGENT_CODE FROM AGENTS a WHERE a.WORKING_AREA = 'New York' AND a.COUNTRY = 'USA')",
    "operation_kind" : "list",
    "schema": "ORDERS, CUSTOMER, AGENTS",
    "confidence" : "100",
    "general_message": "Here is the order description for the order with order number '200110' in the ORDERS table",
    "main_entity" : "order"
}