SELECT
    c.CUST_CODE as CODE,
    c.CUST_NAME as NAME,
    COUNT(DISTINCT(ORDER_DATE || o.CUST_CODE)) as CNT
FROM
    CUSTOMER as c
INNER JOIN
    ORDERS as o
ON
    o.CUST_CODE = c.CUST_CODE
WHERE
    ORDER_DATE >= '2023-07-01'
AND
    ORDER_DATE <= '2023-07-31'
GROUP BY
    c.CUST_CODE
ORDER BY
    CNT  DESC,
    CODE DESC