Practice SQL Window Functions | Xorthax's Trading Post

Tables Used

customers

Column	Type
customerid	bigint
name	text
species	text
contactinfo	text
loyaltystatus	text
joindate	text

orders

Column	Type
orderid	bigint
customerid	bigint
orderdate	timestamp without time zone
totalamount	double precision
status	text

transaction

Column	Type
transactionid	bigint
orderid	double precision
customerid	double precision
supplierid	double precision
transactiontype	text
amount	double precision
currencyid	bigint
transactiondate	text
paymentmethod	text
description	text
status	text
createdat	text
updatedat	text

Expected Output

Column
species
firsttransactiondate

42. Species Transaction Origins

Identify the first transaction date for customers of each species.

Xorthax is curious about the first transaction date for customers of each species. Write a query to display the first transaction date for each species.

Write Your Query