How many unique agent codes are there in the AGENTS table?
{
    "explanation": "I finalized the SQL query by analyzing the schema and context provided. The question asks for the number of unique agent codes in the AGENTS table. I used the AGENTS table and applied the DISTINCT keyword to get the count of unique agent codes.",
    "query" : "SELECT COUNT(DISTINCT AGENTS.AGENT_CODE) AS unique_agents FROM AGENTS",
    "operation_kind" : "aggregation",
    "schema": "AGENTS",
    "confidence" : "100",
    "general_message": "Here is the count of unique agent codes",
    "main_entity" : "agent"
}