题解 | 牛客直播转换率
牛客直播转换率
https://www.nowcoder.com/practice/73bf143cfc7f452a8569c6d7eca380f9
# 1.按照课程id对两张表进行联结 # 2.按照课程id与课程名称分组 # 3.计算转换率 SELECT bt.course_id, ct.course_name, ROUND(SUM(bt.if_sign) * 100 / SUM(bt.if_vw), 2) AS 'sign_rate(%)' FROM behavior_tb AS bt LEFT OUTER JOIN course_tb AS ct ON bt.course_id = ct.course_id GROUP BY bt.course_id, ct.course_name ORDER BY bt.course_id;
海康威视公司福利 338人发布
