with TMP as (select ORDER_NO, CUST_CODE, ORDER_DATE
    from ORDERS
    where ORDER_DATE between "2023-07-01" and "2023-07-31"
    group by ORDER_DATE)

select CODE, NAME, COUNT(CODE) as CNT
from (select CUSTOMER.CUST_CODE as CODE, 
        CUSTOMER.CUST_NAME as NAME,
        TMP.ORDER_NO,
        TMP.ORDER_DATE
    from CUSTOMER
    INNER JOIN TMP
    ON CODE = TMP.CUST_CODE)
group by CODE
order by  CNT desc, CODE desc;