`select cate_fullpath, count(case when yyyy = 2019 then 1 end) as y2019, count(case when yyyy = 2020 then 1 end) as y2020, count(case when yyyy = 2019 and mm between 5 and 10 then 1 end) as may_y2019, count(case when yyyy = 2020 and mm between 5 and 10 then 1 end) as may_y2020, count(case when yyyy = 2019 and mm between 2 and 4 then 1 end) as feb_y2019, count(case when yyyy = 2020 and mm between 2 and 4 then 1 end) as feb_y2020 from navi.route_all where yyyy between 2019 and 2020 and mm between 2 and 10 group by 1`

# [SQL] 카테고리별로 기간합 구하기

Published

Subtitle

Description

Author

**Gunn Kim**

Page ID

Tags

data