Find the agent with the phone number '077-25814763'.
{
    "explanation": "I finalized the SQL query by joining the 'CUSTOMER' and 'ORDERS' tables on the 'CUST_CODE' and 'ORD_NUM' columns respectively. I then joined the 'AGENTS' table on the 'AGENT_CODE' column. I used the 'CUST_COUNTRY' column to filter the agents based on the phone number '077-25814763'. I used the 'AGENT_NAME' column to get the agent's name.",
    "query" : "SELECT A.AGENT_NAME, A.AGENT_CODE FROM AGENTS A JOIN CUSTOMER C ON A.AGENT_CODE = C.CUST_CODE JOIN ORDERS O ON A.AGENT_CODE = O.AGENT_CODE WHERE LOWER(C.CUST_COUNTRY) LIKE '%india%' AND LOWER(A.CUST_COUNTRY) LIKE '%india%' AND LOWER(A.CUST_COUNTRY) LIKE '%077-25814763%'",
    "operation_kind" : "list",
    "schema": "AGENTS, CUSTOMER, ORDERS",
    "confidence" : "100",
    "general_message": "Here is your list of agents with the phone number '077-25814763'",
    "main_entity" : "agent"
}