====
---- QUERY
# multiple levels of aggregation in a subquery
# Taken from subquery.test
select c1, c3, m2
from (
       select c1, c3, max(c2) m2
       from (
              select c1, c2, c3
              from (
                     select int_col c1, tinyint_col c2, max(id) c3
                     from alltypessmall
                     group by 1, 2
                     order by 1,2
                     limit 5
                   ) x
             ) x2
       group by c1, c3
       limit 10
     ) t
where c1 > 0
order by 2, 1 desc
limit 3
---- RESULTS
1,96,1
2,97,2
3,98,3
---- TYPES
int, int, tinyint