SELECT 
a.CUST_CODE as CODE
,CUST_NAME as NAME
,COUNT(a.CUST_CODE) as CNT
,SUM(ORDER_AMNT) as TTL_AMT
,ROUND(AVG(ORDER_AMNT),0) as AVG_AMT
FROM CUSTOMER as a
INNER JOIN ORDERS as o ON a.CUST_CODE = o.CUST_CODE
WHERE 
 ORDER_DATE >= '2023-09-01' 
 and ORDER_DATE <= '2023-09-30' 
GROUP BY a.CUST_CODE
HAVING CNT >=5
ORDER BY 
CNT desc
,AVG_AMT desc
,CODE asc
;