SELECT 
L.CUST_CODE AS CODE
,R.CUST_NAME AS NAME
,L.CNT
,L.TTL_AMT
,L.AVG_AMT
FROM
(SELECT CUST_CODE,COUNT(*) AS CNT,SUM(ORDER_AMNT) AS TTL_AMT,ROUND(SUM(ORDER_AMNT)/COUNT(*),1) AS AVG_AMT FROM ORDERS 
WHERE ORDER_DATE BETWEEN DATE('2023-09-01') AND DATE('2023-09-30')
GROUP BY 1
) L
LEFT JOIN CUSTOMER R
ON L.CUST_CODE = R.CUST_CODE
WHERE L.CNT >= 5
GROUP BY 1,2,3
ORDER BY 5 DESC,3 DESC,1