记得列名带%的要加引号

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