SELECT COUNT(*) as C1, COUNT(A) as CA, COUNT(B) as CB, SUM(A) as SA, SUM(B) as SB from [test].[dbo].[Table_1]
ID A B ----------- ---- ------ 1 1 NULL 2 3 NULL 3 NULL 4