--web 전체
select '200910' monthcode, fn_site_name(site_id) site_name, fn_sex_name(sex_cls) gender, fn_age_name(age_cls) age,
       round(sum(uv)/(select count(*) from copy_ymd where ymd >= '20091001' and ymd <= '20091031')) uv
from
(
    select /*+use_hash(b,a)*/site_id, sex_cls, age_cls,
           round(sum(kc_n_factor)*fn_day_modifier(a.access_day)) uv
    from
    (
        select access_day, site_id, panel_id
        from   tb_day_fact
        where  access_day >= '20091001' and access_day <= '20091031'
        and    site_id in (1206,178,1173)
        group by access_day, site_id, panel_id
    ) a,
    (
        select access_day, panel_id, kc_n_factor, sex_cls, age_cls
        from   tb_day_panel_seg
        where  access_day >= '20091001' and access_day <= '20091031'
    ) b
    where a.access_day = b.access_day
    and   a.panel_id = b.panel_id
    group by a.access_day, site_id, cube(sex_cls,age_cls)
)
group by site_id, sex_cls, age_cls;

select '200910' monthcode, fn_sex_name(sex_cls) gender, fn_age_name(age_cls) age,
       round(sum(uv)/(select count(*) from copy_ymd where ymd >= '20091001' and ymd <= '20091031')) uv
from
(
    select /*+use_hash(b,a)*/sex_cls, age_cls,
           round(sum(kc_n_factor)*fn_day_modifier(a.access_day)) uv
    from
    (
        select access_day, panel_id
        from   tb_day_fact
        where  access_day >= '20091001' and access_day <= '20091031'
        and    site_id in (1206,178,1173)
        group by access_day, panel_id
    ) a,
    (
        select access_day, panel_id, kc_n_factor, sex_cls, age_cls
        from   tb_day_panel_seg
        where  access_day >= '20091001' and access_day <= '20091031'
    ) b
    where a.access_day = b.access_day
    and   a.panel_id = b.panel_id
    group by a.access_day, cube(sex_cls,age_cls)
)
group by sex_cls, age_cls;