SELECT
CUSTOMER.CUST_CODE as CODE,
CUSTOMER.CUST_NAME as NAME,
count(DISTINCT ORDERS.ORDER_DATE) as CNT
FROM
ORDERS INNER JOIN CUSTOMER ON CUSTOMER.CUST_CODE = ORDERS.CUST_CODE
WHERE
ORDERS.ORDER_DATE BETWEEN '2023-07-01' AND '2023-07-31'
GROUP BY ORDERS.CUST_CODE
ORDER BY CNT DESC,
         CODE DESC;