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