The First Transaction Initiative
Tables Used
transaction
ColumnType
transactionidbigint
orderiddouble precision
customeriddouble precision
supplieriddouble precision
transactiontypetext
amountdouble precision
currencyidbigint
transactiondatetext
paymentmethodtext
descriptiontext
statustext
createdattext
updatedattext
Expected Output
Column
customerid
transactionid
transactiondate

18. The First Transaction Initiative

Find the very first recorded purchase for every galactic customer.

The galactic accounting department at Zlacksys 19 needs to identify the first transaction made by each customer. Write a query to display each customer's first transaction based on the transaction date.
Write Your Query