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