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 |
One row per segmentOnly Q1 2024 posted transactionsCount distinct active customersCompare each segment total against the overall average segment total