SQL 문법

select category, 
	main_month, 
    count(*) as '영화 수', 
    sum(view_count) as '총 관객 수'
from 2020_movie_report
group by category, main_month
having main_month = 5
and sum(view_count) >= 3000000
;

SELECT SUBSTRING(address, 1, 2) as region,
       gender,
       COUNT(*)
FROM member
GROUP BY SUBSTRING(address, 1, 2), gender WITH ROLLUP
HAVING region IS NOT NULL
ORDER BY region ASC, gender DESC;

* SQL 순서법칙

1. SELECT

2. FROM

3. WHERE

4. GROUP BY

5. HAVING

6. ORDER BY

7. LIMIT

 

* 실제 실행순서

1. FROM

2. WHERE

3. GROUP BY

4. HAVING

5. SELECT

6. ORDER BY

7. LIMIT