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