SELECT
  ORDERS.CUST_CODE AS CODE,
  CUST_NAME AS NAME,
  COUNT(DISTINCT (ORDER_DATE)) AS CNT
FROM
  ORDERS
  LEFT OUTER JOIN CUSTOMER ON ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
WHERE
  ORDER_DATE BETWEEN "2023-07-01" AND "2023-07-31"
GROUP BY
  CODE
ORDER BY
  CNT desc,
  CODE desc;