select cust_id,order_num from Orders
order by cust_id,order_date desc;

常规操作，order by后面可以跟多个排序列，默认升序不用写，降序要写desc