문서의 선택한 두 판 사이의 차이를 보여줍니다.
양쪽 이전 판 이전 판 | |||
courses_db_2018_과제2-2_answer [2018/12/05 07:59] gsjung |
courses_db_2018_과제2-2_answer [2018/12/05 08:00] gsjung |
||
---|---|---|---|
줄 35: | 줄 35: | ||
예시 | 예시 | ||
< | < | ||
- | WITH major as (SELECT | + | WITH major AS (SELECT |
SELECT major_name, COUNT(major_name) FROM major GROUP BY major_name ORDER BY COUNT(major_name) DESC LIMIT 10; | SELECT major_name, COUNT(major_name) FROM major GROUP BY major_name ORDER BY COUNT(major_name) DESC LIMIT 10; | ||
</ | </ |