What is the receive amount for the customer with the customer code 'C00020' in the CUSTOMER table?
{
    "explanation": "I finalized the SQL query by joining the CUSTOMER and ORDERS tables on the CUST_CODE and AGENT_CODE columns, and then filtering the results to only include the customer with the customer code 'C00020'. I used the SUM aggregation function to calculate the total receive amount.",
    "query" : "SELECT c.CUST_CODE, SUM(o.RECEIVE_AMOUNT) AS total_receive_amount FROM CUSTOMER c JOIN ORDERS o ON c.CUST_CODE = o.CUST_CODE AND c.AGENT_CODE = o.AGENT_CODE WHERE c.CUST_CODE = 'C00020' GROUP BY c.CUST_CODE",
    "operation_kind" : "aggregation",
    "schema": "CUSTOMER, ORDERS",
    "confidence" : "100",
    "general_message": "Here is the total receive amount for the customer with the customer code 'C00020'",
    "main_entity" : "customer"
}