题解 | 牛客直播转换率
牛客直播转换率
https://www.nowcoder.com/practice/73bf143cfc7f452a8569c6d7eca380f9
with a as (select course_id, round(sum(if_sign)/sum(if_vw)*100,2) as sign_rate from behavior_tb group by course_id order by course_id) select a.course_id, b.course_name, a.sign_rate from a left join course_tb b on a.course_id=b.course_id
查看9道真题和解析