select
  CST.CUST_CODE               AS CODE
  ,CST.CUST_NAME              AS NAME
  ,COUNT(*)                   AS CNT
  ,SUM(ORD.ORDER_AMNT)        AS TTL_AMT
  ,ROUND(AVG(ORD.ORDER_AMNT)) AS AVG_AMT
from
  ORDERS AS ORD
  LEFT OUTER JOIN CUSTOMER AS CST
    ON ORD.CUST_CODE = CST.CUST_CODE
where
  ORD.ORDER_DATE >= '2023-09-01' AND ORD.ORDER_DATE <= '2023-09-30'
group by
  CST.CUST_CODE
  ,CST.CUST_NAME
having
  CNT >= 5
order by
  CNT      DESC
  ,AVG_AMT DESC
  ,CODE    ASC
limit 5
;