with distinctDate as(
select
    CUST_CODE
    , ORDER_DATE 
from
    ORDERS o 
where
    ORDER_DATE between '2023-07-01' and '2023-07-31' 
group by
    CUST_CODE
    , ORDER_DATE
)

select
    d.CUST_CODE as 'CODE'
    , c.CUST_NAME as 'NAME'
    , count(*) as 'CNT' 
from
    distinctDate d
        inner join CUSTOMER c 
        on d.CUST_CODE = c.CUST_CODE 
where
    ORDER_DATE between '2023-07-01' and '2023-07-31' 
group by d.CUST_CODE
order by CNT desc
, CODE desc