题解 | #牛客直播转换率#
牛客直播转换率
http://www.nowcoder.com/practice/73bf143cfc7f452a8569c6d7eca380f9
select x.course_id, course_name, round(100 * sum(if_sign) / sum(if_vw), 2) from behavior_tb x join course_tb y using(course_id) group by 1, 2 order by 1
牛客直播转换率
http://www.nowcoder.com/practice/73bf143cfc7f452a8569c6d7eca380f9
select x.course_id, course_name, round(100 * sum(if_sign) / sum(if_vw), 2) from behavior_tb x join course_tb y using(course_id) group by 1, 2 order by 1
相关推荐