SELECT ORDERS.CUST_CODE CODE,CUST_NAME NAME,
COUNT(ORDERS.CUST_CODE) 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',
ORDER_DATE
GROUP BY ORDERS.CUST_CODE,CUST_NAME
ORDER BY CNT DESC,CODE DESC