The First Order Ever Placed
Tables Used
orders
ColumnType
orderidbigint
customeridbigint
orderdatetimestamp without time zone
totalamountdouble precision
statustext
Expected Output
Column
customerid
orderid
totalamount
firstorderdate

41. The First Order Ever Placed

Find the earliest order date and amount for every customer in the galaxy.

Xorthax wants to know the first order placed by each customer in the galaxy. Write a query to find the first order date and the orderid and total amount of the first order for every customer.
Write Your Query