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