题解 | #牛客直播转换率#
牛客直播转换率
http://www.nowcoder.com/practice/73bf143cfc7f452a8569c6d7eca380f9
select c.course_id,course_name,round(sum(if_sign)*100/count(if_vw),2) from course_tb c join behavior_tb b where c.course_id=b.course_id group by c.course_id,course_name