SELECT
 a.CUST_CODE as CODE
 ,c.CUST_NAME as NAME
 ,COUNT(a.CUST_CODE) as CNT
FROM
 (
 SELECT
  CUST_CODE
  ,ORDER_DATE
 FROM
  ORDERS
 WHERE
  ORDER_DATE >= '2023-07-01' and ORDER_DATE < '2023-08-01'
 GROUP BY
  CUST_CODE
  ,ORDER_DATE
 ) a
 inner join
 CUSTOMER c
 on a.CUST_CODE = c.CUST_CODE
GROUP BY
 a.CUST_CODE
ORDER BY
 CNT desc
 ,CODE desc