How is this SQL query verified?

This exercise runs directly in your browser using official PostgreSQL 16 compiled to WebAssembly (PGlite). Your query results are checked for row counts, columns, and data values with instant automated diff grading.

Sanctions List Screening with Case-Insensitive Pattern Matching — SQL Practice Problem

About the “Sanctions List Screening with Case-Insensitive Pattern Matching” SQL Problem

Business Scenario

Global banks must continuously screen wire transfer beneficiary names against OFAC (Office of Foreign Assets Control) sanctions lists to block terrorism and sanctioned state entities.

Expected Output & Criteria

Flagged wire transfers matching sanctioned names on official watchlists.

Database Table Schema (PostgreSQL DDL)

PostgreSQL 16 WASM

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

CREATE TABLE sanctions_blacklist (
        sanction_id INT PRIMARY KEY,
        sanctioned_entity_name VARCHAR(100) NOT NULL,
        sanction_program VARCHAR(50) NOT NULL,
        listing_date DATE NOT NULL
      );

      CREATE TABLE outgoing_wires (
        wire_id VARCHAR(16) PRIMARY KEY,
        beneficiary_name VARCHAR(100) NOT NULL,
        amount_usd NUMERIC(10, 2) NOT NULL
      );

Target SQL Clauses & Operators

JOINUPPERORDER BY

Want more Business Analytics practice?

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

View Business Analytics Track→