Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --데이터단위 일간
- --데이터범위 2009년 8월, 2009년 10월 (2개월 각각)
- --추출항목
- --1) 연령별 일별 UV
- --2) 연령별 일별 시간대 UV
- --추출대상 네이버 프론트 페이지.(SITE ID = 178)
- select /*+ use_hash(b, a) */
- access_day, time_cd, fn_age_name(age_cls) age,
- round(sum(kc_n_factor) * fn_day_modifier(access_day)) uv
- from
- (
- select access_day, time_cd, site_id, panel_id
- from ch_month_daytime_fact
- where access_day >= '20090801'
- and access_day <= '20090831'
- and site_id = 178
- group by access_day, time_cd, site_id, panel_id
- ) a inner join
- (
- select access_day, panel_id, kc_n_factor, age_cls
- from tb_day_panel_seg
- where access_day >= '20090801'
- and access_day <= '20090831'
- ) b
- using (access_day, panel_id)
- group by access_day, cube(time_cd, age_cls);
Add Comment
Please, Sign In to add comment