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