WITH UniqueOrders AS (
  SELECT DISTINCT
    CUST_CODE,
    ORDER_DATE
  FROM ORDERS
  WHERE ORDER_DATE >= '2023-07-01' AND ORDER_DATE <= '2023-07-31'
)

SELECT
  c.CUST_CODE AS CODE,
  c.CUST_NAME AS NAME,
  COUNT(uo.ORDER_DATE) AS CNT
FROM CUSTOMER c
INNER JOIN UniqueOrders uo ON c.CUST_CODE = uo.CUST_CODE
GROUP BY c.CUST_CODE, c.CUST_NAME
ORDER BY CNT DESC, CODE DESC;