What is the agent commission for the agent named 'Alford' in the AGENTS table?
{
    "explanation": "I finalized the SQL query by joining the AGENTS and CUSTOMER tables on the AGENT_CODE column, 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 named 'Alford' and calculated the commission for each agent.",
    "query" : "SELECT A.AGENT_NAME, A.COMMISSION FROM AGENTS A JOIN CUSTOMER C ON A.AGENT_CODE = C.CUST_CODE JOIN ORDERS O ON C.CUST_CODE = O.CUST_CODE AND A.AGENT_NAME = O.AGENT_NAME WHERE LOWER(A.AGENT_NAME) = 'alford'",
    "operation_kind" : "aggregation",
    "schema": "AGENTS, CUSTOMER, ORDERS",
    "confidence" : "100",
    "general_message": "Here is the agent commission for the agent named 'Alford'",
    "main_entity" : "agent"
}