with order_date as (
    SELECT DISTINCT
        o.ORDER_DATE
        ,o.cust_code
    FROM ORDERS o
    WHERE o.ORDER_DATE between '2023-07-01' and '2023-07-31'
)
SELECT 
    c.cust_code as CODE
    ,c.cust_name as NAME
    ,count(1) as CNT
FROM order_date o
LEFT JOIN CUSTOMER c
    ON  o.cust_code = c.cust_code
group by code,name
order by CNT DESC,CODE DESC

;