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