Noruj.com
easy

Identify Pending High-Value Transactions

In the heavily regulated FinTech and banking industry, monitoring money flow is critical for compliance, fraud prevention, and liquidity management. Large transfers often require manual review or automated risk scoring before they are fully cleared and settled into customer accounts.

The Risk and Compliance team at your financial institution has requested a new dashboard report. They need to keep a close eye on substantial transactions that are currently stuck in a pending state, as these represent potential bottlenecks or compliance flags that require immediate investigation.

You have been given access to the transactions table, which logs all incoming and outgoing money movements. The relevant columns for your task are transaction_id (the unique identifier), account_id (the customer's account), amount (the monetary value of the transfer), status (the current state, such as 'Completed', 'Pending', or 'Failed'), and created_at (the timestamp of initiation).

Write a SQL query to retrieve these specific records for the risk team. Please ensure your output strictly adheres to the following conditions:

  • Select only the transaction_id, account_id, and amount columns.

  • Filter the results to include only transactions with a status of exactly 'Pending'.

  • Only include transactions where the amount is $10,000.00 or greater.

  • Sort the final results by the amount in descending order, so the largest pending transactions appear at the very top.

Common Pitfall: String comparisons in SQL can sometimes be case-sensitive depending on the database collation. It is best practice to match the exact casing of the status string (e.g., 'Pending' instead of 'pending'). Furthermore, remember to use the >= operator to ensure amounts of exactly 10,000 are not accidentally excluded.

Hint: You will need to use the AND logical operator in your WHERE clause to satisfy both the status condition and the numerical amount threshold simultaneously.

1
2
3
4
5
Preparing...
Identify Pending High-Value Transactions

In the heavily regulated FinTech and banking industry, monitoring money flow is critical for compliance, fraud prevention, and liquidity management. Large transfers often require manual review or automated risk scoring before they are fully cleared and settled into customer accounts. The Risk and Compliance team at your financial institution has requested a new dashboard report. They need to keep a close eye on substantial transactions that are currently stuck in a pending state, as these represent potential bottlenecks or compliance flags that require immediate investigation. You have been given access to the transactions table, which logs all incoming and outgoing money movements. The relevant columns for your task are transaction_id (the unique identifier), account_id (the customer's account), amount (the monetary value of the transfer), status (the current state, such as 'Completed', 'Pending', or 'Failed'), and created_at (the timestamp of initiation). Write a SQL query to retrieve these specific records for the risk team. Please ensure your output strictly adheres to the following conditions: Select only the transaction_id , account_id , and amount columns. Filter the results to include only transactions with a status of exactly 'Pending'. Only include transactions where the amount is $10,000.00 or greater. Sort the final results by the amount in descending order, so the largest pending transactions appear at the very top. Common Pitfall: String comparisons in SQL can sometimes be case-sensitive depending on the database collation. It is best practice to match the exact casing of the status string (e.g., 'Pending' instead of 'pending'). Furthermore, remember to use the >= operator to ensure amounts of exactly 10,000 are not accidentally excluded. Hint: You will need to use the AND logical operator in your WHERE clause to satisfy both the status condition and the numerical amount threshold simultaneously.

Table Setup (SQL Schema)

CREATE TABLE transactions (transaction_id INT PRIMARY KEY, account_id INT, amount DECIMAL(10,2), status VARCHAR(20), created_at TIMESTAMP); INSERT INTO transactions (transaction_id, account_id, amount, status, created_at) VALUES (1, 1001, 15000.00, 'Pending', '2026-04-12 08:30:00'), (2, 1002, 500.00, 'Pending', '2026-04-12 09:00:00'), (3, 1003, 25000.50, 'Completed', '2026-04-11 14:20:00'), (4, 1004, 10000.00, 'Pending', '2026-04-12 10:15:00'), (5, 1005, 50000.00, 'Failed', '2026-04-10 11:45:00'), (6, 1006, 12500.75, 'Pending', '2026-04-12 11:30:00');
Home Videos Quiz Blog