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