SELECT
    ORDERS.CUST_CODE AS CODE
    , CUSTOMER.CUST_NAME AS NAME
    , count(distinct ORDERS.ORDER_DATE) AS CNT
FROM
    ORDERS
 INNER JOIN CUSTOMER 
     ON ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
WHERE
    ORDERS.ORDER_DATE between '2023-07-01' and '2023-07-31'
group by
    ORDERS.CUST_CODE
ORDER BY
    CNT DESC
    ,CODE DESC
;