How does the GROUP BY clause manage the NULL values?

You mean, when you GROUP BY a nullable column? All rows with a NULL in the column are treated as if NULL was another value.

If a grouping column contains null values, all null values are considered equal, and they are put into a single group.

http://technet.microsoft.com/en-us/library/ms177673.aspx