Find all customers from the USA
{
    "explanation": "I finalized the SQL query by analyzing the schema and context provided. The question asks to find all customers from the USA. I used the CUSTOMER table to achieve this by joining it with the AGENTS table on the AGENT_CODE field. I filtered the results to only include customers from the USA by checking the CUST_COUNTRY field.",
    "query" : "SELECT 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 FROM CUSTOMER C JOIN AGENTS A ON C.AGENT_CODE = A.AGENT_CODE WHERE LOWER(C.CUST_COUNTRY) LIKE '%usa%'",
    "operation_kind" : "list",
    "schema": "CUSTOMER, AGENTS",
    "confidence" : "100",
    "general_message": "Here is your list of customers from the USA",
    "main_entity" : "customer"
}