select
    CUST_CODE as CODE
    , ( select CUST_NAME from CUSTOMER as B where A.CUST_CODE = B.CUST_CODE )  as NAME
    , count(*) as CNT
    , sum(ORDER_AMNT) as TTL_AMT
    , round (avg(ORDER_AMNT), 0 ) as AVG_AMT
from ORDERS as A
where ORDER_DATE between '2023-09-01' and '2023-09-30'
group by CUST_CODE
having count(*) >= 5
order by CNT desc , AVG_AMT desc , CODE
limit 5