SQL and Case Study Screening | Dataford Interview Questions

Tell me about your SQL experience and how you would handle a basic SQL task and a credit card case study.

Use the tables below to answer a basic analysis task on American Express card activity. Keep the response focused on the requested result set.

Output

Return one row per cardholder and month with the month-level spend and dispute counts.
Include cardholder_name, statement_month, total_spend, approved_spend, dispute_count, and high_risk_flag.
Include only cardholders who had at least one transaction in the month.
Sort by statement_month ascending, then total_spend descending, then cardholder_name ascending.

cardholders

Column	Type	Description
cardholder_idPK	INT	Unique cardholder identifier
cardholder_name	VARCHAR(100)	Cardholder display name
segment	VARCHAR(50)	Customer segment

card_transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
cardholder_id	INT	References cardholders.cardholder_id
transaction_date	DATE	Transaction date
amount	NUMERIC(10,2)	Transaction amount
status	VARCHAR(20)	Transaction status such as APPROVED, DECLINED, or DISPUTED
merchant_category	VARCHAR(80)	Merchant category

Your question is SQL and Case Study Screening. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.