下面的伪代码：
SELECT count(CoumntA) *< 0*,count(CoumntA) * > 0* FROM dbo.TableA
SELECT SUM(CASE WHEN CoumntA < 0 THEN 1 ELSE 0 END) AS LessThanZero,SUM(CASE WHEN CoumntA > 0 THEN 1 ELSE 0 END) AS GreaterThanZero FROM TableA
