Question: are table aliases allowed in the order by clause?
Answer: Yes, you can certainly use column aliases in your "order by" clause.