Pivot Table Fraud Loss Summary | Dataford Interview Questions

Walk me through how you would use a Pivot Table to summarize monthly fraud losses by region and payment type for Uber.

Use the fraud_losses table and provide the SQL equivalent of the requested summary. Exclude records missing the fraud date, region, payment type, or loss amount.

Output

One row per month, region, and payment type.
Columns: loss_month, region, payment_type, and total_fraud_loss.
Sort by month, region, then payment type ascending.

Schema

fraud_losses

Column	Type	Description
fraud_loss_idPK	INT	Unique identifier for the fraud loss record
fraud_date	DATE	Date when the fraud loss was recorded
region	VARCHAR(50)	Uber operating region associated with the loss
payment_type	VARCHAR(30)	Payment method associated with the loss
loss_amount	DECIMAL(12,2)	Fraud loss amount in USD

Your question is Pivot Table Fraud Loss Summary. Start with the requirements and the one table 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.

Problem