DB Exercises
0
← Exercises/
Fundamentals•6 of 12
PrevNext
FundamentalsBeginnerPRO

Flagged Cross-Border Wire Transfers

Scenario

A global neo-bank AML (Anti-Money Laundering) compliance officer must inspect high-risk international wire transfers. Federal regulations mandate auditing transfers between $10,000 and $50,000 USD where the automated fraud risk score is 75 or higher.

Task
Query the `wire_transfers` table to identify transfers where: - `amount_usd` is between **10,000.00** and **50,000.00** (inclusive) using `BETWEEN` - `risk_score` is greater than or equal to **75** - `destination_country` is **not** `'USA'` Return: 1. `transfer_id` 2. `destination_country` 3. `amount_usd` 4. `risk_score` Order by `risk_score` descending, then by `amount_usd` descending.
Expected Output Format

High-risk non-US wire transfers between $10k and $50k, sorted by highest risk score first.

Input Tables & Sample Data0 tables
Loading database schema...
Need a hint?
query.sql|Local Sandbox
Loading SQL editor...
Click "Run" or press ⌘ + Enter to execute your query

About the “Flagged Cross-Border Wire Transfers” SQL Problem

Business Scenario

A global neo-bank AML (Anti-Money Laundering) compliance officer must inspect high-risk international wire transfers. Federal regulations mandate auditing transfers between $10,000 and $50,000 USD where the automated fraud risk score is 75 or higher.

Expected Output & Criteria

High-risk non-US wire transfers between $10k and $50k, sorted by highest risk score first.

Database Table Schema (PostgreSQL DDL)

PostgreSQL 16 WASM

This challenge executes directly against the following relational schema in your browser:

CREATE TABLE wire_transfers (
        transfer_id VARCHAR(16) PRIMARY KEY,
        sender_iban VARCHAR(34) NOT NULL,
        destination_country VARCHAR(3) NOT NULL,
        amount_usd NUMERIC(12, 2) NOT NULL,
        risk_score INT NOT NULL,
        status VARCHAR(20) NOT NULL
      );

Target SQL Clauses & Operators

WHEREBETWEENORDER BY

Want more Fundamentals practice?

Explore the full syllabus of 12 exercises, syntax guides, and interview pitfalls.

View Fundamentals Track→