Select ORDERS.CUST_CODE as CODE,
CUSTOMER.CUST_NAME as NAME,
COUNT(DISTINCT ORDERS.ORDER_DATE) as CNT
from ORDERS
    inner join CUSTOMER
        on CUSTOMER.CUST_CODE = ORDERS.CUST_CODE
where ORDERS.ORDER_DATE between '2023-07-01' and '2023-07-31'
group by CODE, NAME
order by CNT DESC, CODE DESC;