Is this a possible sub query with standard SQL
===

Is it possible to run one query and get resultset A that's sorted by an age field desc,
then query result A for any records that have, lets say a color field that equals 5
AND among that group with matching fields, sort them by the height column desc 
And return all of the results at one time:

so data might look like this:

age color height
4    5     7
3    6     1
2    9     2 
6    5     3

output of 1st part would yield (sorted by age)
age color height
6    5     1
4    5     7
3    6     2
2    9     3

output of final part of query would yield (subset with equal color, sorted by height):
age color height
4    5     7
6    5     1
3    6     2
2    9     3

