select
      OD.CUST_CODE as CODE
    , CS.CUST_NAME as NAME
    , count(ORDER_NO) as CNT
    , sum(OD.ORDER_AMNT) as TTL_AMT
    , round(AVG(OD.ORDER_AMNT), 0) as AVG_AMT 
from
    ORDERS as OD     
    inner join CUSTOMER as CS 
        on CS.CUST_CODE = OD.CUST_CODE 
where
   (OD.ORDER_DATE >= '2023-09-01' 
       and OD.ORDER_DATE <= '2023-09-30') 
group by
    CODE
having count(ORDER_NO) >= 5
order by
      CNT desc
    , AVG_AMT desc
    , CODE asc
limit 5;