Problem Statement
Assign a sequential row number to each customer's orders, ordered by their order date. Display customer_id, order_date, total_amount, and the sequence number aliased as `order_sequence`.
Skills Evaluated
ROW_NUMBEROVERPARTITION BY
Write your SQL query in the editor on the right and click **Run Query**. The system runs your query and compares the result dataset with the official solution. Results must match row-for-row, column-for-column.
Expected Output Format
Executing expected result set...SQL Query WorkspaceSQLite v3.45 (WASM Mode)
QUICK INSERT:
1