# Fraudulent Transactions SQL interview question

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/questions/3071/fraudulent-transactions
Source observed: 2026-11-04T23:34:36.358Z
Last checked: 2026-11-04T23:34:36.358+00:00
Indexed: 2026-11-05T17:31:38.719+00:00

---

# Fraudulent Transactions

**Difficulty:** Medium

We provide this SQL coding interview question about identifying suspicious receipts for Visa’s Anti-Money Laundering department. The task uses customer and transaction data to find customers with at least 2 receipts matching the suspicious patterns `'999'`, `'1234'`, or `'XYZ'`.

## Question details

- **Roles:** [Data Scientist](https://www.aced.io/questions?role=data-science), [Product Manager](https://www.aced.io/questions?role=pm), [Data Engineer](https://www.aced.io/questions?role=data-engineer), [Data Analyst](https://www.aced.io/questions?role=data-analyst)
- **Companies:** [Stripe](https://www.aced.io/questions?company=stripe), [Revolut](https://www.aced.io/questions?company=revolut)
- **Categories:** [Coding](https://www.aced.io/questions?type=coding), [SQL](https://www.aced.io/questions?type=sql)
- **Interview count:** 6 interviews
- **Last asked:** 5 months ago
- **Saved by:** 18 users

## Scenario and schema

Visa’s AML department identifies potentially suspicious financial transactions to support compliance with global financial regulations. Large-transaction receipts typically have an associated receipt number.

### `customers`

- `customer_id` (integer): unique customer identifier
- `first_name` (string): customer’s first name
- `last_name` (string): customer’s last name

### `transactions`

- `transaction_id` (integer): unique transaction identifier
- `customer_id` (integer): customer associated with the transaction
- `receipt_number` (string): transaction receipt number
- `amount` (float): amount involved in the transaction

## Task

Return every suspicious receipt number made by potential money launderers. A customer is flagged when they have 2 or more receipts matching `'999'`, `'1234'`, or `'XYZ'`.

The output must contain:

- `first_name`
- `last_name`
- `receipt_number`
- `no_of_offences`

No community answers have been contributed yet. The page includes Question, Solution, and Community tabs; the solution is locked in the rendered interface. The code panel offers SQLite, Editor, Share, Output, Test Results, and Console views. Running code requires [signing up](https://www.aced.io/signup?src=lesson).

## Interview experiences

Two shared experiences are available:

1. [Stripe Product Manager interview](https://www.aced.io/experiences/stripe-product-manager-interview-2e0110) — Stripe, 5 months ago, Product Manager, Entry Level / L3

   > “By far the most technically challenging interview process I've ever had to do for new grad product management roles. Successive coding questions in a constrained time block.”

2. [Revolut Data Scientist interview](https://www.aced.io/experiences/revolut-data-scientist-interview-ac4820) — Revolut, 5 months ago, Data Scientist

   > “good, the process had been very through with a coding round as well.The coding was more on implemneting and solving ML problem”

## Related questions

- [Most Recent Transaction](https://www.aced.io/questions/3043/most-recent-transaction)
- [Validate Bitcoin Transactions](https://www.aced.io/questions/3101/validate-bitcoin-transactions)
- [Describe the model you would build to predict fraudulent credit card transactions.](https://www.aced.io/questions/3738/model-predict-credit-card-fraud)

## Related courses

### [Data Analyst Interview Prep](https://www.aced.io/courses/data-analytics)

![Data Analyst Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/72OTqij57b2TklhaD2vrdV/be0dae6242904970d1696e5a4d858e18/AdobeStock_1357126576.jpeg?w=800&h=800&fm=webp&q=75)

Ace your data analyst interviews—whether you're targeting product, marketing, or business analyst roles. Tackle real take-home case studies, sharpen your technical and dashboarding skills, and get strategies from interviewers at top tech companies and startups.

### [Data Science Interview Prep](https://www.aced.io/courses/data-science)

![Data Science Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/3U4C5C0OkDR0UeGch4AmlE/7ad489430b676a088cb973307fe77884/Data_Science_Interview_Prep_Course.jpeg?w=800&h=800&fm=webp&q=75)

Land your dream data science role at Google, Amazon, Microsoft, Meta, Apple, and other top companies. Learn from mock interviews, frameworks, and advice from senior candidates. Practice statistics, experimentation, coding, SQL, machine learning, behavioral interviews, and more.

Detailed company statistics are available through [Upgrade](https://www.aced.io/upgrade?src=questions).

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3071%2Ffraudulent-transactions&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3071%2Ffraudulent-transactions). Opening a form does not execute a tool.