About the “Cross-Border Wire Transfers with Beneficiary KYC Level” SQL Problem
Business Scenario
Compliance auditors must verify that international wire transfers exceeding $15,000 USD only flow to accounts with Verified KYC status ('Tier_3_Enhanced'). Unverified accounts receiving large transfers represent severe compliance violations.
Expected Output & Criteria
Compliance violation list of high-value wires sent to unverified accounts.
Database Table Schema (PostgreSQL DDL)
PostgreSQL 16 WASMThis challenge executes directly against the following relational schema in your browser:
CREATE TABLE bank_accounts (
account_id INT PRIMARY KEY,
account_number VARCHAR(30) NOT NULL,
account_holder VARCHAR(100) NOT NULL,
kyc_status VARCHAR(30) NOT NULL
);
CREATE TABLE cross_border_transfers (
transfer_id VARCHAR(16) PRIMARY KEY,
beneficiary_acc_id INT REFERENCES bank_accounts(account_id),
amount_usd NUMERIC(12, 2) NOT NULL,
created_at TIMESTAMP NOT NULL
);Target SQL Clauses & Operators
JOINWHEREORDER BY
Want more Joins practice?
Explore the full syllabus of 12 exercises, syntax guides, and interview pitfalls.