Consider a table with a Title column and a Units column where the Units is the number of sales of a particular Title. There are more columns like a date and such.

I would like to select the total number of sales for each Title:

select 
    distinct(Title), 
    sum(Units) 
from my_table 
group by Title 
order by Title;

That's easy enough. The part that is giving me trouble is that I would like to combine that data into a single column (or third column as necessary). I would essentially like to produce a "Title sum(Units)" similar to the third column in this query:

select 
    distinct(Title) as myTitle, 
    sum(Units) as totalSales, 
    concat(myTitle, ' ', totalSales) as combinedLabel  
from my_table 
group by Title 
order by Title;

However, you can't reference column aliases when doing these kinds of things, so I'm at a loss. Any suggestions?