decode , not in, as

SELECT
 userId AS 회원아이디,
 userLevel AS 회원레벨,
 DECODE( locate,  'kor',  '한국',  'jpn',  '일본',  'usa',  '미국',  'chn',  '짱개',  'tha',  '대만',  '기타' ) AS 국가,
 userName AS 회원이름
FROM CP_PROPOSE
--IN('level1')
WHERE userId NOT IN('level1','level2','level3','level4','level5')

 
SELECT COUNT(userId) AS 회원수
FROM CP_PROPOSE
WHERE CP_STEPID
--IN('level1')
NOT IN('level1','level2','level3','level1''level4')