select
  CUSTOMER.CUST_CODE as CODE,
  CUSTOMER.CUST_NAME as NAME,
  count(ORDER_NO) as CNT,
  sum(ORDER_AMNT) as TTL_AMT,
  round(cast(sum(ORDER_AMNT) as real)/count(ORDER_NO), 0) as AVG_AMT
from CUSTOMER
inner join ORDERS on CUSTOMER.CUST_CODE = ORDERS.CUST_CODE

where
  ORDER_DATE between '2023-09-01' and '2023-09-30'

group by
  CUSTOMER.CUST_CODE,
  CUSTOMER.CUST_NAME

having
  count(ORDER_NO) >= 5

order by
CNT desc,
AVG_AMT desc,
CODE asc

limit 5