SELECT
 ORDERS.CUST_CODE AS 'CODE',
 CUST_NAME AS 'NAME',
-- ORDER_DATE
 COUNT(ORDER_DATE) AS 'CNT'

FROM
CUSTOMER
INNER JOIN ORDERS
ON  ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
--    ORDERS.EMP_CODE = CUSTOMER.EMP_CODE

WHERE 
 (ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31')
GROUP BY
 ORDERS.CUST_CODE
ORDER BY
 COUNT(ORDER_DATE) DESC,
 CODE DESC