SELECT 
        CS.CUST_CODE AS 'CODE',
        CS.CUST_NAME AS 'NAME',
        COUNT(OD.ORDER_NO) AS 'CNT'
FROM    CUSTOMER CS
        INNER JOIN ORDERS AS OD
        ON CS.CUST_CODE = OD.CUST_CODE
GROUP BY CS.CUST_CODE
ORDER BY CNT DESC, CODE DESC;