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 >='2023-07-01' AND ORDER_DATE <='2023-07-31')
GROUP BY
 ORDERS.CUST_CODE
ORDER BY
 COUNT(ORDER_DATE) DESC,
 CODE DESC