语法错误 在 "[" 或附近的

Question

SELECT t_SC.Cid as 课程ID,t_course.Cname as 课程名称,
SUM(CASE WHEN score BETWEEN 85 AND 100 THEN 1 ELSE 0 END) AS [100 - 85],
SUM(CASE WHEN score BETWEEN 70 AND 85 THEN 1 ELSE 0 END) AS [85 - 70],
SUM(CASE WHEN score BETWEEN 60 AND 70 THEN 1 ELSE 0 END) AS [70 - 60],
SUM(CASE WHEN score < 60 THEN 1 ELSE 0 END) AS [60 - ]
FROM t_SC,t_Course where t_SC.Cid = t_Course.Cid
GROUP BY t_SC.Cid,t_course.cname;

[Err] 错误: 语法错误 在 "[" 或附近的
LINE 1: ...en score between 85 and 100 then 1 else 0 end) as [100 - 85]...

Answer 1

AS 后面是一这个域的名称，你用[100-85]，这个是不符合要求的字符串，你可以尝试用类似S100_85这样的符合常量定义的字符串来表示。追问

题目是这样的
统计列印各科成绩,各分数段人数:按课程ID,课程名称,[100-85],[85-70],[70-60],[ <60]显示

追答

如果你一定要用[100-85]，可以考虑加上双引号，"[100-85]"