Integration Methods You’ve Used | Dataford Interview Questions

What types of integration methods have you worked with, and when did you choose each one?

Use the supplied integration method catalog and experience records to produce a concise SQL summary of documented choices. Include active methods even when no experience has been recorded.

Output

One row per active integration method.
Return method_name, usage_count, latest_decision_date, and selection_contexts.
Show contexts alphabetically within each method, use NULL where no experience exists, and order methods alphabetically.

Schema

integration_methods

Column	Type	Description
method_idPK	INT	Unique integration method identifier
method_name	VARCHAR(100)	Integration method name
description	VARCHAR(255)	Short description of the method
is_active	BOOLEAN	Whether the method should appear in the active catalog

integration_experiences

Column	Type	Description
experience_idPK	INT	Unique experience record identifier
method_id	INT	Referenced integration method
chosen_when	VARCHAR(255)	Context in which the method was selected
decision_date	DATE	Date the integration decision was recorded
system_name	VARCHAR(100)	System involved in the experience

Your question is Integration Methods You’ve Used. 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