Using a CTE of each customer's first order date, list name and first_order for customers whose first order was in 2024 Q1 (Jan–Mar).
7 rows with columns name, first_order — first 3 shown:
| # | ||
|---|---|---|
| 1 | Aarav Shah | 2024-01-05 |
| 2 | Diya Patel | 2024-01-12 |
| 3 | Kabir Singh | 2024-01-20 |
Run your code to see the output here.