SELECT
    O.CUST_CODE AS CODE,
    C.CUST_NAME AS NAME,
    COUNT(distinct ORDER_DATE) AS CNT
FROM
    ORDERS AS O
INNER JOIN
    CUSTOMER AS C
ON
    O.CUST_CODE = C.CUST_CODE
WHERE
    DATE(ORDER_DATE) BETWEEN '2023-07-01' AND '2023-07-31'
GROUP BY
    O.CUST_CODE
    --,DT
ORDER BY
    CNT DESC,
    CODE DESC