select
    CUST_CODE as CODE,
    CUST_NAME as NAME,
    CUST_USER_NAME as USER_NAME
from
    CUSTOMER
where
    CUST_NAME like '株式会社%' or CUST_NAME like '%商事%'
order by
    1 desc