SELECT * FROM (
SELECT 
CUS.CUST_CODE  AS CODE
,CUS.CUST_NAME AS NAME,

COUNT(CUS.CUST_CODE) as CNT,
SUM(OD.ORDER_AMNT) as TTL_AMT,
ROUND(AVG(OD.ORDER_AMNT),0) as AVG_AMT

 FROM 
ORDERS OD
INNER JOIN CUSTOMER  CUS
ON OD.CUST_CODE = CUS.CUST_CODE

WHERE
OD.ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY CUS.CUST_CODE,CUS.CUST_NAME
ORDER BY CNT DESC,AVG_AMT DESC, CODE 
) WHERE CNT >= 5
LIMIT 5