Mock interview. You're interviewing for a fraud analyst job on a credit card team. The interviewer says: "Our fraud losses jumped in March. Find out what happened and how big it was." You have card_transactions, where is_fraud marks purchases confirmed as fraud.
"Show transactions, fraud transactions, the fraud rate and fraud dollars per week, from the week of 2 February to the week of 30 March."
Expected output
fraud_rate as a percentage rounded to 2 decimals; fraud_amount 0 when there's none; sorted by week_startExample of the shape (made-up values):
| week_start | transactions | fraud_txns | fraud_rate | fraud_amount |
|---|---|---|---|---|
| 2026-02-02 | 350 | 2 | 0.57 | 150.00 |
Hints, the later steps and the answer come with Pro.
Step 1 of 3
Write your query here. Ctrl + Enter submits.