Hard
Window Functions
Customer Order Sequence
Number each customer's orders chronologically. Return columns: order_id, order_date, customer_id, order_number. Order results by: order_date, id) AS order_number FROM orders ORDER BY customer_id, order_number.
Preparing the interactive SQL workspace...