Problem
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.
Schema
customer_segments
| Column | Type | Description |
|---|---|---|
| customer_id | ||
| segment_name | ||
| enrollment_channel |
amex_cards
| Column | Type | Description |
|---|---|---|
| card_id | ||
| customer_id | ||
| card_product | ||
| open_date |
card_transactions
| Column | Type | Description |
|---|---|---|
| transaction_id | ||
| card_id | ||
| transaction_date | ||
| amount | ||
| merchant_category |
You are practicing as a guest. Sign up free to run your code against the sample data. Your draft stays right here.
