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