Plaid API Documentation Questions | Dataford Interview Questions

Questions based on the Plaid API documentation.

Using the provided Plaid Item and transaction data, write a PostgreSQL query that summarizes completed transaction activity during January 2025 for every active Item.

Output

One row per active Item with item_id, institution_name, transaction_count, total_amount, and activity_status.
Include active Items with no qualifying transactions, using zero totals and No activity.
Order by total_amount descending, then item_id ascending.

Schema

plaid_items

Column	Type	Description
item_idPK	VARCHAR(32)	Plaid Item identifier
institution_name	VARCHAR(100)	Financial institution name
status	VARCHAR(20)	Current Item status

plaid_transactions

Column	Type	Description
transaction_idPK	VARCHAR(32)	Plaid transaction identifier
item_id	VARCHAR(32)	Identifier of the related Plaid Item
account_id	VARCHAR(32)	Plaid account identifier
transaction_date	DATE	Date of the transaction
amount	NUMERIC(12,2)	Transaction amount
pending	BOOLEAN	Whether the transaction is pending
transaction_name	VARCHAR(150)	Display name for the transaction

Your question is Plaid API Documentation Questions. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem