SELECT
    O.CUST_CODE AS CODE
    ,C.CUST_NAME AS NAME
    ,COUNT(O.CUST_CODE) AS CNT
    ,SUM(ORDER_AMNT) AS TTL_AMT
    ,ROUND(CAST(SUM(ORDER_AMNT) AS REAL) / CAST(COUNT(O.CUST_CODE)AS REAL),0) AS AVG_AMT
FROM
    ORDERS AS O
LEFT JOIN
    CUSTOMER AS C
ON
    O.CUST_CODE = C.CUST_CODE
WHERE
    ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
    
GROUP BY
    O.CUST_CODE
    
HAVING
    COUNT(O.CUST_CODE) >=5
ORDER BY
    COUNT(O.CUST_CODE) DESC
    ,ROUND(CAST(SUM(ORDER_AMNT) AS REAL) / CAST(COUNT(O.CUST_CODE)AS REAL),0) DESC
    ,O.CUST_CODE DESC

LIMIT 5;