order by 可以和多个column进行处理
mysql> SELECT name, species, birth FROM pet
ORDER BY species, birth DESC;
The DESC keyword applies only to the column name immediately preceding it (birth); it does not affect the species column sort order.
# 意思就是说,species是asc,birth是desc