SELECT CODE,
       NAME,
       COUNT(*) AS CNT
  FROM(SELECT O.CUST_CODE AS CODE,
              C.CUST_NAME AS NAME,
              COUNT(*) AS CNT
         FROM ORDERS O
         LEFT JOIN CUSTOMER C
           ON O.CUST_CODE = C.CUST_CODE
        GROUP BY ORDER_DATE
       )
 GROUP BY CODE
 ORDER BY CNT DESC,
          CODE DESC