Order by Order, One by One
Tables Used
orders
ColumnType
orderidbigint
customeridbigint
orderdatetimestamp without time zone
totalamountdouble precision
statustext
Expected Output
Column
customerid
orderid
orderdate
orderrank

17. Order by Order, One by One

Assign a row number to each customer's orders based on the order date.

Xorthax wants to identify the sequence of orders placed by each customer based on the order date. Write a query to assign a row number to each order for every customer.
Write Your Query