select * from studentorder by class,sbirthday desc
SELECT s.*,YEAR(NOW())-YEAR(s.SBIRTHDAY) as age from student s ORDER BY class desc,age DESC;