SQL Server Small Thigs-- But Overlooked

1.Count(*) is the only aggregate that considers null values in the group. Consider the column Quantity with values {10,20,30,40,NULL,50}
Count(*) will give 6
Count(Quantity) will give 5

--More to Come..