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 |