select 
c.CUST_CODE as CODE,
c.CUST_NAME as NAME,
o.CNT as CNT
from CUSTOMER as c
join 
(
    select CUST_CODE, count(*) as CNT
    from
    (
        select distinct CUST_CODE, ORDER_DATE
        from ORDERS
        where ORDER_DATE >= '2023-07-01' and ORDER_DATE <= '2023-07-31'
    )as o1 
    group by CUST_CODE
) as o
on c.CUST_CODE = o.CUST_CODE
order by CNT desc, CODE desc