The Final Purchase Report
Tables Used
orders
ColumnType
orderidbigint
customeridbigint
orderdatetimestamp without time zone
totalamountdouble precision
statustext
Expected Output
Column
customerid
orderid
totalamount
lastorderdate

45. The Final Purchase Report

Discover the most recent order date and amount for every customer.

Xorthax wants to know the last order placed by each customer in the galaxy. Write a query to find the last order date, order id and amount for every customer.
Write Your Query