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.0) 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
ORDER BY 3 DESC,5 DESC,1