case when and then else 一直报AND 附近语法错误

Question

SELECT
	工号,
	rpusername,
	MAX ( createtime ) createtime,
	
	SUM (CASE WHEN 系数= '1.2系数' 
	AND (( AND 球镜 >= - 1.75 AND 球镜 <= - 1.25 AND 柱镜 = - 0.00 
	
	AND  cdefine1 != '2207407' AND  cdefine1 != '2207408' AND  cdefine1 != '2207409' ) 
  
	OR ( 球镜  < - 1.00 OR ( 球镜  > - 0.00 AND 球镜  < 0.25 ) OR 球镜 > 1.00 OR 柱镜  < - 4.00 OR 柱镜  > - 0.00 )) 
	
	THEN 数量 ELSE 0 END )  '1.2系数',
	
	SUM (折算产量) 折合产量,
	SUM (数量) 实际产量 

Answer 1

case 后面那一行，连着两个 and，去掉左括号内的第一个就行。

	SUM (CASE WHEN 系数= '1.2系数' 
	AND ((球镜 >= - 1.75 AND 球镜 <= - 1.25 AND 柱镜 = - 0.00