Das Stichwort ist "Derived Table":

Select Benutzer, .... from (
select case bla bla end as Bentzer
from abc
group by ....
) hugo