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