ORDER BY and GROUP BY Together
If ORDER BY is used with GROUP BY, the ordering attributes are limited to those listed in the GROUP BY clause.
select age from Person where ((age > 100 and zip = 20144) or time > 10)
group by age order by age ascending
select age, zip from Person where ((age > 100 and zip = 20144) or time > 10)
group by age, zip order by age asc, zip desc