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