simple question about group by and custom groups
Directly using GROUP BY, no. You can still get the results you want, though, and there are many ways to accomplish it. Such as UNION:

SELECT 'red', COUNT(*) FROM color_table WHERE color_name='red'
UNION
SELECT 'colors different than red', COUNT(*) FROM color_table WHERE color_name &lt;&gt; 'red'