select
    o.CUST_CODE as CODE
    , c.CUST_NAME as NAME
    , count(*) as CNT
    , sum(ORDER_AMNT) as TTL_AMT
    , ROUND(avg(ORDER_AMNT), 0) as AVG_AMT 
from
    ORDERS as o 
    left join CUSTOMER as c 
        on o.CUST_CODE = c.CUST_CODE 
where
    ORDER_DATE >= '2023-09-01' 
    and ORDER_DATE <= '2023-09-30' 
    and (select count(*) from ORDERS group by CUST_CODE) > 5 
group by
    o.CUST_CODE 
order by
    CNT desc
    , AVG_AMT desc
    , CODE asc 
limit
    5