Which agent is based in London in the AGENTS table?
{
    "explanation": "I finalized the SQL query by joining the AGENTS and CUSTOMER tables on the AGENT_CODE column, and then joining the resulting table with the ORDERS table on the CUST_CODE and AGENT_CODE columns. I filtered the results to only include agents based in London by using the LIKE operator with the LOWER function.",
    "query" : "SELECT A.AGENT_CODE, A.AGENT_NAME, A.WORKING_AREA, A.COUNTRY FROM AGENTS A JOIN CUSTOMER C ON A.AGENT_CODE = C.AGENT_CODE JOIN ORDERS O ON C.CUST_CODE = O.CUST_CODE WHERE LOWER(A.WORKING_AREA) LIKE '%london%'",
    "operation_kind" : "list",
    "schema": "AGENTS, CUSTOMER, ORDERS",
    "confidence" : "100",
    "general_message": "Here is your list of agents based in London",
    "main_entity" : "agent"
}