select
ORDERS.CUST_CODE as CODE
, CUST_NAME as NAME
, COUNT(1) as CNT
, SUM(ORDER_AMNT) as TTL_AMT
, ROUND(AVG(ORDER_AMNT)) as AVG_AMT
from ORDERS join CUSTOMER on ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
where order_date >= '2023-09-01' and order_date <= '2023-09-30'
group by CODE, CUST_NAME
having CNT >= 5
order by CNT desc, AVG_AMT desc, CODE
limit 5