sql 笔记

select rid,ganyu_type,sum(cur_page_0_click_pv),sum(cur_total_click_pv),sum(cur_dura),sum(cur_page_0_show_pv),avg(self_build_duration),sum(cur_share_cnt),sum(cur_zan_pv),sum(cur_comment_cnt),sum(cur_collect_cnt),sum(cur_un_collect_cnt),sum(cur_consume_dura),sum(cur_consume_pv),sum(cur_guanzhu_pv)
from ${table_name}
WHERE rid in ('9996368285113346476','9986379402244099460')
group by rid,ganyu_type;
;