题解 | #牛客直播转换率#

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