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
    , avg(ORDER_AMNT) % count(*) 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