SELECT ORDERS.CUST_CODE AS CODE,
       CUSTOMER.CUST_NAME AS NAME,
       count(distinct ORDER_DATE) as CNT
        from ORDERS
             left join CUSTOMER on ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
            where
                ORDERS.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
            group by
                CUSTOMER.CUST_NAME
            order by
                CNT desc,
                CODE desc