You should be able to use the expression in your GROUP BY as long as you use the same expression used in the column list. Here's an example (a poor one)
SELECT count(*), 'fullname'+au_lname+au_fname as fullname from authors group by 'fullname'+au_lname+au_fname