select course_id,course_name,round(sum(if_sign)/sum(if_vw)*100,2) "sign_rate(%)"
from
course_tb join behavior_tb using(course_id)
group by course_id,course_name
order by course_id