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