SELECT
    OD.CUST_CODE AS CODE,
    CU.CUST_NAME AS NAME,
    COUNT(
    DISTINCT ORDER_DATE
    ) AS CNT
FROM
    ORDERS AS OD
JOIN CUSTOMER AS CU
    ON OD.CUST_CODE = CU.CUST_CODE
WHERE
    ORDER_DATE BETWEEN "2023-07-01" AND "2023-07-31"
GROUP BY
    NAME
ORDER BY
    CNT DESC,
    CODE DESC