What is the grade of the customer named 'Albert' in the CUSTOMER table?
{
    "explanation": "I finalized the SQL query by analyzing the schema and context provided. The question asks for the grade of the customer named 'Albert' in the CUSTOMER table. I used the CUSTOMER table and filtered the results using the WHERE clause with the condition 'CUST_NAME = 'Albert''. I also used the GROUP BY clause to group the results by the 'CUST_CODE' field and the MAX aggregation function to get the maximum grade.",
    "query" : "SELECT C.CUST_CODE, MAX(C.GRADE) AS MAX_GRADE FROM CUSTOMER C WHERE LOWER(C.CUST_NAME) = 'albert' GROUP BY C.CUST_CODE",
    "operation_kind" : "aggregation",
    "schema": "CUSTOMER",
    "confidence" : "100",
    "general_message": "Here is the grade of the customer named 'Albert'",
    "main_entity" : "customer"
}