SELECT 
L.CUST_CODE AS CODE
,R.CUST_NAME AS NAME
,L.CNT
,L.TTL_AMT
,L.AVG_AMT
FROM
(SELECT CUST_CODE,COUNT(CUST_CODE) 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 HAVING CNT >= 5
) L
LEFT JOIN CUSTOMER R
ON L.CUST_CODE = R.CUST_CODE
GROUP BY 1,2,3
ORDER BY 3 DESC,5 DESC,1