select
cus.CUST_CODE as CODE,
cus.CUST_NAME as NAME,
count(distinct ord.ORDER_DATE) as CNT

from
CUSTOMER as cus
inner join ORDERS as ord
on cus.CUST_CODE = ord.CUST_CODE

where
ord.ORDER_DATE between "2023-07-01" and "2023-07-31"

group by
CODE

order by 
CNT desc,CODE desc;