Your question is Compare Spend Across Card Segments. Start with the requirements and the three tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Write a PostgreSQL query that compares Q1 2024 spend across customer segments using Card Member transaction data. Return one row per segment with active customer count, total spend, average spend per active customer, and a label showing whether the segment is above or below the average segment spend for the quarter.
| Column | Type | Description |
|---|---|---|
| customer_id | ||
| segment_name | ||
| enrollment_channel |
| Column | Type | Description |
|---|---|---|
| card_id | ||
| customer_id | ||
| card_product | ||
| open_date |
| Column | Type | Description |
|---|---|---|
| transaction_id | ||
| card_id | ||
| transaction_date | ||
| amount | ||
| merchant_category |