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