Build a Basic CRUD App with SQL and Apex | Dataford Interview Questions

Tell me about building a basic CRUD operations application using SQL and Apex.

For the SQL portion, demonstrate the read operation by summarizing qualifying records for active customers. Return every active customer, including those without a qualifying record. Only completed records dated on or after 2026-01-01 count toward the summary.

Output

One row per active customer with customer_id, customer_name, completed_order_count, completed_order_total, last_completed_order_date, and activity_status.
Use 0 for customers without qualifying records and No completed orders for their status.
Sort by customer_id ascending.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer display name
status	VARCHAR(20)	Customer lifecycle status

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer associated with the order
status	VARCHAR(20)	Order processing status
order_date	DATE	Date the order was recorded
amount	NUMERIC(12,2)	Order amount

Your question is Build a Basic CRUD App with SQL and Apex. 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