select CUST.CUST_CODE as CODE,
CUST.CUST_NAME as NAME,
COUNT(OD.ORDER_NO) as CNT,
SUM(OD.ORDER_AMNT) as TTL_AMT,
ROUND(AVG(OD.ORDER_AMNT)) as AVG_AMT
from CUSTOMER CUST
inner join ORDERS OD
on CUST.CUST_CODE = OD.CUST_CODE
where OD.ORDER_DATE between '2023-09-01' and '2023-09-30'
and CNT >= 5
order by CNT DESC,AVG_AMT DESC,CODE
Limit 5;