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