Re: 문제517. (오늘의 마지막 문제1) 스티브 잡스 연설문에는 긍정단어가 몇개가 있는가?

[19기_윤지윤]

SELECT word, count(*) FROM stev_word2 s WHERE EXISTS

(SELECT pword FROM positive_eng p WHERE p.pword = s.word)

GROUP BY word ORDER BY 2 desc;

--우선 긍정 단어가 맞는지 확인하기 위해 word와 count를 동시에 진행.

SELECT count(*) FROM stev_word2 s WHERE EXISTS

(SELECT pword FROM positive_eng p WHERE p.pword = s.word)

ORDER BY count(*) desc;

--총 82.

SELECT nvl(word, '긍정 단어 갯수') AS 단어, count(*)

FROM stev_word2 s WHERE EXISTS

(SELECT pword FROM positive_eng p WHERE p.pword = s.word)

GROUP BY cube(word) ORDER BY 2 desc;

--  합계를 맨 위에 올려놔서 보기 편하게 수정

SELECT nvl(lower(word), '긍정 단어 갯수') AS 단어, count(*)

FROM stev_word2 s WHERE EXISTS

(SELECT pword FROM positive_eng p WHERE lower(p.pword) = lower(s.word))

GROUP BY cube(word) ORDER BY 2 desc;