SELECT MAIN.*
FROM
(
SELECT 
CUS.CUST_CODE AS CUST
,CUS.CUST_NAME AS NAME
,COUNT(ORD.ORDER_NO)   AS CNT
,SUM(ORD.ORDER_AMNT)   AS TTL_AMT
,ROUND(AVG(ORD.ORDER_AMNT))   AS AVG_AMT
FROM CUSTOMER CUS
INNER JOIN
ORDERS ORD
ON CUS.CUST_CODE = ORD.CUST_CODE
AND ORD.ORDER_DATE >= '2023-09-01' 
AND ORD.ORDER_DATE <= '2023-09-30'
GROUP BY CUS.CUST_CODE,CUS.CUST_NAME
ORDER BY 
COUNT(ORD.ORDER_NO)   DESC
,ROUND(AVG(ORD.ORDER_AMNT))   DESC
,CUS.CUST_CODE ASC
)MAIN
where MAIN.CNT > 4
LIMIT 5