WITH temp AS (
    SELECT 
        o.CUST_CODE AS CODE,
        c.CUST_NAME AS NAME,
        COUNT(DISTINCT o.ORDER_DATE) 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, c.CUST_NAME
)
SELECT 
    CODE,
    NAME,
    CNT
FROM 
    TEMP
ORDER BY 
    CNT DESC, 
    CODE DESC;