Sadly using the renamed column name in a group by or order by doesn't work on all database engines.