select
        a.cust_code as "CODE",
        b.cust_name as "NAME",
        a.cnt as "CNT"
    from(
        
        select
            cust_code,
            count(distinct order_date) as cnt
        from orders
        where order_date like '2023-07-%'
        group by 1) as a
    inner join customer as b
    using(cust_code)
    order by 3 desc, 1 desc