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