Core Java and Spring Microservices | Dataford Interview Questions

Core Java, Spring framework, Microservices, SQL. For the SQL portion, use the provided cardholders and transactions tables to identify qualifying cardholders for calendar year 2025. Include only approved transactions when calculating totals and counts.

Output

One row per qualifying cardholder.
Columns: cardholder_id, cardholder_name, approved_transaction_count, and approved_total.
Include cardholders with at least two approved transactions and an approved total of at least 1000.
Order by approved_total descending, then cardholder_id ascending.

Schema

cardholders

Column	Type	Description
cardholder_idPK	INT	Unique cardholder identifier
cardholder_name	VARCHAR(100)	Cardholder display name
region	VARCHAR(50)	Cardholder billing region

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
cardholder_id	INT	Cardholder associated with the transaction
transaction_date	DATE	Transaction processing date
status	VARCHAR(20)	Transaction processing status
amount	DECIMAL(12,2)	Transaction amount

Your question is Core Java and Spring Microservices. 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