MySQL在navicat里报错，如何解决？

Question

这是表，还有报错请专家帮忙看看，解决一下这个问题。

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SUM(CASE course.coursename WHEN "数据库"THEN score.scorecj ELSE 0 END)AS"数' at line 4

Answer 1

As跟后面的别名之间要有空格，As前面也加个空格。