Loyalty Group Order Milestones
Tables Used
customers
ColumnType
customeridbigint
nametext
speciestext
contactinfotext
loyaltystatustext
joindatetext
orders
ColumnType
orderidbigint
customeridbigint
orderdatetimestamp without time zone
totalamountdouble precision
statustext
Expected Output
Column
loyaltystatus
customerid
firstorderdate

44. Loyalty Group Order Milestones

Track the first order date for each customer loyalty tier.

The merchants guild wants to find the first order placed by customers in each loyalty status group. Write a query to find the first order date for each group along with the first customer.
Write Your Query