MYSQL IFNULL 表达式

SQL语句：IFNULL 表达式

SELECT
	SUM(IFNULL(XUELIXUEWEI LIKE '%研究生%','0') AND 旗区 = #{旗区}) A,
	SUM(IFNULL(XUELIXUEWEI LIKE '%大学%','0') AND 旗区 = #{旗区}) B,
	SUM(IFNULL(XUELIXUEWEI LIKE '%本科%','0') AND 旗区 = #{旗区}) C,
	SUM(IFNULL(XUELIXUEWEI LIKE '%专%','0') AND 旗区 = #{旗区}) D,
	SUM(IFNULL(XUELIXUEWEI LIKE '%高中%' OR XUELIXUEWEI LIKE '%初中%' OR XUELIXUEWEI LIKE '%小学%','0') AND 旗区 = #{旗区}) G
FROM SHOUYE_TONGZHANRENYUANSHUJU