MySQL deducing fields dynamically
In most situations, the recalculation of an expression is much less of a performance burden than any solution.  So, don't worry about it.

You have another issue -- The GROUP BY does not include the first thing in the SELECT, so the value you will get for that is unpredictable.