select CUST.CUST_CODE as CODE,
CUST.CUST_NAME as NAME,
count(OD.CUST_CODE) as CNT,
SUM(ORDER_AMNT) as TTL_AMT,
ROUND(AVG(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;