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