select c.course_id,course_name,round(sum(if_sign)*100/count(if_vw),2) from course_tb c join behavior_tb b where c.course_id=b.course_id group by c.course_id,course_name