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