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