The Second Order Chronicles
Tables Used
orders
ColumnType
orderidbigint
customeridbigint
orderdatetimestamp without time zone
totalamountdouble precision
statustext
Expected Output
Column
customerid
orderid
totalamount
secondorderdate

49. The Second Order Chronicles

Uncover each customer's second recorded order and its amount.

Xorthax wants to know the second order placed by each customer. Write a query to display the second order date and amount for each customer.
Write Your Query