with JOIN_TABLE as(
SELECT * FROM CUSTOMER
LEFT OUTER JOIN ORDERS
ON CUSTOMER.CUST_CODE = ORDERS.CUST_CODE)

select 
CUST_CODE as CODE,
CUST_NAME as NAME,
count(ORDER_NO) as CNT,
sum(ORDER_AMNT) as TTL_AMT,
round(avg(ORDER_AMNT)) as AVG_AMT
from JOIN_TABLE
where ORDER_DATE BETWEEN '2023-09-01' and '2023-09-30' 
group by CUST_CODE
having CNT >= 5
order by CNT desc, AVG_AMT desc, CODE asc