SELECT
O.CUST_CODE AS CODE,
C.CUST_NAME AS NAME,
COUNT(DISTINCT O.ORDER_DATE) AS CNT

FROM ORDERS AS O
 INNER JOIN CUSTOMER AS C
  ON O.CUST_CODE = C.CUST_CODE
  
WHERE 
 O.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'


GROUP BY
CODE,NAME


ORDER BY
 CNT DESC,
 CODE DESC;