The Galactic Max Order Hunt
Tables Used
orders
ColumnType
orderidbigint
customeridbigint
orderdatetimestamp without time zone
totalamountdouble precision
statustext
Expected Output
Column
customerid
orderid
orderdate
totalamount
maxorderamount

10. The Galactic Max Order Hunt

Discover each customer's largest single order; sorted by time.

Xorthax is curious about the largest single order placed by each of his intergalactic customers. Write a query to calculate the maximum order amount for each customer, ordered by the order date.
Write Your Query