SELECT
orders.CUST_CODE AS CODE,
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

between '2023-07-01' and '2023-07-31'
group by 1
order by 3 desc,1 desc