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