SQL Set Membership Query | Dataford Interview Questions

Your question is SQL Set Membership Query. Start with the requirements and the three tables on the right.

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

Problem

Alegeus WealthCare administrators need to identify active Healthcare FSA accounts whose approved 2025 reimbursements exceed the account's annual contribution. Write a PostgreSQL query using the member, account, and claim data.

Requirements

Include only active Healthcare FSA accounts.
Include only claims with approved status submitted during calendar year 2025.
Return the member, account type, total approved reimbursement, and approved claim count.
Keep only accounts where total approved reimbursement is greater than the annual contribution, then sort by reimbursement descending.

Schema

members

Column	Type	Description
member_idPK	INT	Unique member identifier
member_name	VARCHAR(100)	Member's full name

accounts

Column	Type	Description
account_idPK	INT	Unique benefit account identifier
member_id	INT	Member who owns the account
account_type	VARCHAR(40)	Type of benefit account
status	VARCHAR(20)	Current account status
annual_contribution	NUMERIC(12,2)	Annual contribution limit or election

claims

Column	Type	Description
claim_idPK	INT	Unique claim identifier
account_id	INT	Account associated with the claim
status	VARCHAR(20)	Claim processing status
submitted_at	DATE	Date the claim was submitted
reimbursement_amount	NUMERIC(12,2)	Amount reimbursed for the claim