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