select
    CUST_CODE as CODE
  , CUST_NAME as NAME
  , count(ORDER_AMNT) as CNT
  , sum(ORDER_AMNT)   as TTL_AMT
  , round(avg(ORDER_AMNT), 0)   as AVG_AMT
from
  ORDERS o
  inner join CUSTOMER c using(CUST_CODE)
where
  '2023-09-01' <= ORDER_DATE and ORDER_DATE < '2023-10-01'
group by
  CUST_CODE
having
  CNT >= 5
order by
    CNT desc
  , AVG_AMT desc
  , CODE    asc
limit 5
;