select
    ord.CUST_CODE AS CODE
    ,cus.CUST_NAME AS NAME
    ,COUNT(DISTINCT ord.ORDER_DATE) AS CNT
from
    ORDERS as ord
inner join CUSTOMER as cus
    on ord.CUST_CODE = cus.CUST_CODE
where
    ORDER_DATE BETWEEN date('2023-07-01') AND date('2023-07-31')

group by
    CODE
    ,NAME
order by
    CNT desc
    ,CODE desc