What is the average advance amount in the ORDERS table?
{
    "explanation": "I finalized the SQL query by analyzing the schema and context provided. The question asks for the average advance amount in the ORDERS table. I used the ORDERS table and applied the AVG aggregation function on the ADVANCE_AMOUNT column.",
    "query" : "SELECT 'ORDERS' AS main_entity, 'Average Advance Amount' AS description, AVG(o.ADVANCE_AMOUNT) AS average_advance_amount FROM ORDERS o",
    "operation_kind" : "aggregation",
    "schema": "ORDERS",
    "confidence" : "100",
    "general_message": "Here is the average advance amount in the ORDERS table",
    "main_entity" : "ORDERS"
}