WITH
wk_order(CUST_CODE, ordercount, orderamount)
AS
 (
 SELECT
  CUST_CODE
  ,count(ORDER_NO) as ordercount
  ,sum(ORDER_AMNT) as orderamount
 FROM
  ORDERS
 WHERE
  ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
 GROUP BY
  CUST_CODE
 HAVING
  ordercount >= 5
  and orderamount > 0
 )

SELECT
 wk_order.CUST_CODE as CODE
 ,CUST_NAME as NAME
 ,ordercount as CNT
 ,orderamount as TTL_AMT
 ,round((orderamount/ordercount),1) as AVG_AMT
FROM
 wk_order
 inner join
 CUSTOMER
 on wk_order.CUST_CODE = CUSTOMER.CUST_CODE
ORDER BY
 CNT desc
 ,AVG_AMT desc
 ,CODE asc
LIMIT 5