excel公式转成SqlServer的SQL语句

excel公式转成SqlServer的SQL

下面的是excel公式
=COUNTIFS(在途详表!M:M,A4,在途详表!C:C,"当天",在途详表!D:D,"",在途详表!J:J,"TRUE",在途详表!G:G,"否")+COUNTIFS(在途详表!M:M,A4,在途详表!C:C,"空",在途详表!D:D,"",在途详表!J:J,"TRUE",在途详表!G:G,"否");

#excel的公式转SQL
SELECT [地市],
SUM( 
	CASE WHEN [预约天数] LIKE '当天' 
		or [未完成大类（在途）] LIKE '' 
	THEN 1 END )+SUM( 
	CASE WHEN
		[未完成大类（在途）] LIKE '' 
		or [预约天数] LIKE '空' 
	THEN 1 END )
	总数
FROM
	ZJ_ZYWT_1 
WHERE
	[是否在途] LIKE 'Y' AND [是否可判断为用户原因] LIKE '否'
GROUP BY
	[地市];
	
SELECT [地市],
SUM( 
	CASE WHEN [预约天数] LIKE '空' AND [预约天数] LIKE '当天'
		or [未完成大类（在途）] LIKE '' 
	THEN 1 END )总数
FROM
	ZJ_ZYWT_1 
WHERE
	[是否在途] LIKE 'y' AND [是否可判断为用户原因] LIKE '否'
GROUP BY
	[地市];