SELECT CUSTOMER.CUST_CODE 'CODE',CUSTOMER.CUST_NAME 'NAME',COUNT(CUSTOMER.EMP_CODE) 'CNT'
FROM CUSTOMER 
INNER JOIN ORDERS ON CUSTOMER.CUST_CODE = ORDERS.CUST_CODE
WHERE ORDERS.ORDER_DATE BETWEEN 2023-07-01 AND 2023-07-31
ORDER BY CUSTOMER.CUST_CODE DESC,CUSTOMER.CUST_NAME DESC ;