SELECT
    CUSTOMER.CUST_CODE AS CODE
    , CUSTOMER.CUST_NAME AS NAME
    , count(*) AS CNT
    , SUM(ORDERS.ORDER_AMNT) AS TTL_AMT
    , ROUND(AVG(ORDERS.ORDER_AMNT),0) AS AVG_AMT
FROM
 ORDERS 
 INNER JOIN CUSTOMER 
     ON ORDERS.CUST_CODE  = CUSTOMER.CUST_CODE
WHERE
    ORDERS.ORDER_DATE BETWEEN '2023-09-01' and '2023-09-30'
GROUP BY
    ORDERS.CUST_CODE
ORDER BY
    CNT DESC
    , AVG_AMT DESC
    , CODE ASC
LIMIT 5
;