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