SELECT
    t1.CUST_CODE AS CODE,
    CUST_NAME AS NAME,
    COUNT(*) AS CNT
FROM
    CUSTOMER t1
    LEFT JOIN (
        SELECT
            *
        FROM
            ORDERS
        GROUP BY
            CUST_CODE,
            ORDER_DATE
    ) t2 ON t1.CUST_CODE = t2.CUST_CODE
WHERE
    t2.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
GROUP BY
    t1.CUST_CODE
ORDER BY
    CNT DESC,
    CODE DESC;