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