with temp as(
    select
        o.CUST_CODE AS CODE
        ,c.CUST_NAME AS NAME
        ,COUNT(o.CUST_CODE) AS CNT
    from
        ORDERS o
    LEFT JOIN
        CUSTOMER c
    ON o.CUST_CODE = c.CUST_CODE
    where
        o.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
    GROUP BY
        o.CUST_CODE
        ,o.ORDER_DATE
    )

select CODE,NAME,count(CODE) AS CNT
from temp
group by CODE
order by
    CNT desc
    ,CODE desc
;