select -- 从所有列中过滤出两列
    cust_id,
    order_num 
from
    (
        select
            *
        from
            Orders
        order by
            cust_id,
            order_date desc
    ) temp -- 子查询按照客户Id和时间排序，并返回所有列