select CUST_CODE as CODE, CUST_NAME as NAME, count(*) as CNT, sum(ORDER_AMNT) as TTL_AMT,  round(cast(sum(ORDER_AMNT) as float)/count(*)) as AVG_AMT
from ORDERS
left join CUSTOMER using (CUST_CODE)
where "2023-09-01" <= ORDER_DATE and ORDER_DATE <= "2023-09-30"
group by CUST_CODE, CUST_NAME
having count(*) >= 5
order by CNT desc, AVG_AMT desc, CODE
limit 5