SELECT
    CUST_CODE AS CODE
    ,CUST_NAME AS NAME
    ,CUST_USER_NAME AS USER_NAME
FROM
    CUSTOMER
WHERE
    CUST_NAME LIKE '株式会社%'
AND    
    CUST_NAME LIKE '%商事%'
ORDER BY
    1 DESC