What is the total outstanding amount across all customers in the CUSTOMER table?
{
    "explanation": "I finalized the SQL query by analyzing the schema and context provided. The question asks for the total outstanding amount across all customers in the CUSTOMER table. I used the CUSTOMER table and applied the rules to write a query that calculates the total outstanding amount using the OPENING_AMT, RECEIVE_AMOUNT, and OUTSTANDING_AMOUNT columns.",
    "query" : "SELECT c.CUST_CODE, c.CUST_NAME, SUM(c.OPENING_AMT + c.RECEIVE_AMOUNT + c.OUTSTANDING_AMT) AS TOTAL_OUTSTANDING_AMOUNT FROM CUSTOMER c GROUP BY c.CUST_CODE, c.CUST_NAME",
    "operation_kind" : "aggregation",
    "schema": "CUSTOMER",
    "confidence" : "100",
    "general_message": "Here is the total outstanding amount across all customers",
    "main_entity" : "customer"
}