select c.course_id,course_name,
round(sum(if_sign)/sum(if_vw)*100,2) as sign_rate
from course_tb c
join behavior_tb b
on c.course_id = b.course_id
group by c.course_id,course_name
order by c.course_id

简单