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