SELECT 
    ORDERS.CUST_CODE AS CODE,
    CUST_NAME AS NAME,
    COUNT(*) AS CNT,
    SUM(ORDER_AMNT) AS TTL_AMT,
    ROUND(AVG(ORDER_AMNT), 1) AS AVG_AMT
FROM 
    ORDERS
LEFT JOIN
    CUSTOMER
ON
    ORDERS.CUST_CODE=CUSTOMER.CUST_CODE
WHERE 
    ORDER_DATE >= '2023-09-01' AND ORDER_DATE <= '2023-09-30'
GROUP BY 
    ORDERS.CUST_CODE, CUST_NAME
HAVING 
    COUNT(*) >= 5
ORDER BY 
    CNT DESC,
    AVG_AMT DESC,
    CODE ASC
LIMIT 5;