SELECT
c.CUST_CODE CODE,
c.CUST_NAME NAME,
COUNT(*) CNT,
SUM(ORDER_AMNT) TTL_AMT,
round(AVG(ORDER_AMNT),0) AVG_AMT

FROM ORDERS o
inner join 
CUSTOMER c
on o.CUST_CODE=c.CUST_CODE


where

ORDER_DATE >= '2023-09-01'
AND
ORDER_DATE <= '2023-09-30'

group by 
1,2
having CNT >= 5

order by CNT desc, AVG_AMT desc, CODE asc