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