sqlserver实现分类汇总

SELECT SUM
	( CASE WHEN area_name IS NULL THEN 0 ELSE 1 END ) AS '有值',
	COUNT ( id ) AS "总数" 
FROM
	beike_property