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