Problem
Write a PostgreSQL query that compares June 2024 cardmember performance across region and segment. Your result should show active cardmembers, total billed amount, average billed amount per active cardmember, and a label indicating whether each group is above or below the overall portfolio average. Only keep groups with at least 2 active cardmembers.
Schema
| Column | Type | Description |
|---|---|---|
| customer_id | ||
| customer_name | ||
| region | ||
| segment | ||
| signup_date |
| Column | Type | Description |
|---|---|---|
| transaction_id | ||
| customer_id | ||
| transaction_date | ||
| billed_amount | ||
| merchant_category |
Practicing as: Financial Analyst interview at American ExpressHi, I'll play your American Express interviewer for the Financial Analyst role. Candidates describe these interviews as mostly positive and moderately difficult, so expect me to be friendly and conversational. Take your time with the question above and answer like we're in the room.
You are practicing as a guest. Sign up free to run your code against the sample data. Your draft stays right here.
