select A.STIE_NO , A.SITE_NM, CASE WHEN (SELECT B.NM FROM TABLE B, TABLE C WHERE A.SOTE_NO=C.NO AND B.CODE=C.SUBCODE AND B.CODE='415000') THEN '1' WHEN (SELECT B.NM FROM TABLE B, TABLE C WHERE A.SOTE_NO=C.NO AND B.CODE=C.SUBCODE AND B.CODE='416000') THEN '2' ELSE '3' END AS TEST FROM TABLE A
위에 처럼 했는데 계속 MISSING EXPRESSION 이라고 뜨는데 어떻게 고쳐야할까요?