Return a default value in group by if selected column is null
You should be able to use COALESCE(your_column, 'Unknown'):


  The COALESCE function returns the first of its arguments that is not null.


This is not specific to GROUP BY, although you'll certainly need to use it both in your SELECT column expression and in the GROUP BY expression (as usual when using GROUP BY).