easy · ~8 min
Lifecycle analytics needs a table capturing each customer's first (earliest) purchase from purchases.
purchases
Write a query that returns one row per customer:
customer_id
purchase_time
amount
Input contract: purchase_id is unique and non-null; customer_id, purchase_time, and amount are non-null. Within any given customer_id, all purchase_time values are distinct. A customer may have one or many purchases.
purchase_id