with order_dis as(
    select
        distinct ORDER_DATE,
        CUST_CODE
    from
        ORDERS
    where
        ORDER_DATE between '2023-07-01'
        and '2023-07-31'
)
select
    order_dis.CUST_CODE as CODE,
    CUSTOMER.CUST_NAME as NAME,
    count(order_dis.ORDER_DATE) as CNT
from
    order_dis
    inner join CUSTOMER on order_dis.CUST_CODE = CUSTOMER.CUST_CODE
group by
    CODE,
    NAME
order by
    CNT desc,
    CODE desc