select 
    ct.course_id,
    ct.course_name,
    round(sum(if_sign=1)/sum(if_vw=1)*100,2) as 'sign_rate(%)'
from course_tb ct
join behavior_tb bt
  on bt.course_id = ct.course_id
group by 
     ct.course_id,
     ct.course_name