9.27

select (distinct) *
from student
where score>80
group by class
order by age
distribute by col_list
sort by col_list
limit 10