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