题解 | #牛客直播转换率#
牛客直播转换率
https://www.nowcoder.com/practice/73bf143cfc7f452a8569c6d7eca380f9
select course_id, course_name, round(sum(if_sign)/sum(if_vw)*100,2) as sign_rate from course_tb inner join behavior_tb using(course_id) group by course_id,course_name order by course_id
我还以为%是包含在了横列名称