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