Retrieve the agent with the highest commission.
{
    "explanation": "I finalized the SQL query by identifying the need to find the agent with the highest commission. I used the AGENTS table to get the highest commission and then joined it with the CUSTOMER table to get the corresponding agent name.",
    "query" : "SELECT A.AGENT_NAME, A.AGENT_CODE FROM AGENTS A JOIN CUSTOMER C ON A.AGENT_CODE = C.AGENT_CODE WHERE A.COMMISSION = (SELECT MAX(C.COMMISSION) FROM AGENTS A JOIN CUSTOMER C ON A.AGENT_CODE = C.AGENT_CODE) GROUP BY A.AGENT_NAME, A.AGENT_CODE",
    "operation_kind" : "aggregation",
    "schema": "AGENTS, CUSTOMER",
    "confidence" : "100",
    "general_message": "Here is the agent with the highest commission",
    "main_entity" : "agent"
}