Find all agents with a phone number starting with '0'
{
    "explanation": "I finalized the SQL query by analyzing the schema and context provided. The question asks for agents with a phone number starting with '0'. I used the 'CUST_PHONE_NO' field in the 'CUSTOMER' table to filter agents with a phone number starting with '0'. I used the 'AGENT_CODE' field in the 'AGENTS' table as the reference for the 'CUST_PHONE_NO' field.",
    "query" : "SELECT A.AGENT_CODE, A.AGENT_NAME, A.WORKING_AREA, A.COMMISSION, A.PHONE_NO, A.COUNTRY FROM AGENTS A WHERE LOWER(A.PHONE_NO) LIKE LOWER('%0%')",
    "operation_kind" : "list",
    "schema": "AGENTS, CUSTOMER",
    "confidence" : "100",
    "general_message": "Here is your list of agents with phone numbers starting with '0'",
    "main_entity" : "agent"
}