select
  O.CUST_CODE AS CODE
  , C.CUST_NAME AS NAME
  , COUNT(*) AS CNT
  , SUM(ORDER_AMNT) AS TTL_AMT
  , ROUND(AVG(ORDER_AMNT)) AS AVG_AMT
from
  ORDERS AS O
  inner join CUSTOMER AS C
    on O.CUST_CODE = C.CUST_CODE
where
  ORDER_DATE between '2023-09-01' and '2023-09-30'
group by
  CODE
order by
  CNT desc
  , AVG_AMT desc
  , CODE
limit 5
;