First Purchase Date per User

Problem

Return each user_id and their first purchase_date from purchases.

Why This Matters

First-event queries power cohorts, retention analysis, onboarding funnels, and lifecycle reporting.

Schema

purchases(user_id INTEGER, purchase_date TEXT)

Examples

Constraints

• Return the exact requested result.
• Handle common edge cases.
• Keep the solution readable before optimizing.