SQL For Marketing Touchpoints | Dataford Interview Questions

How would you write a SQL query to identify customers who have interacted with three specific marketing touchpoints in the last 30 days?

Assume the required touchpoints are Analog Devices Website, EngineerZone, and ADI Webinar. Return only customers who interacted with all three during the period.

Output

One row per qualifying customer
Columns: customer_id, customer_name, touchpoints_interacted, and last_interaction_at
Include exactly three distinct touchpoints and sort by customer_id ascending

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(150)	Customer or account name
email	VARCHAR(255)	Customer email address

marketing_interactions

Column	Type	Description
interaction_idPK	INT	Unique interaction identifier
customer_id	INT	Customer associated with the interaction
touchpoint_name	VARCHAR(100)	Marketing touchpoint involved in the interaction
channel	VARCHAR(50)	Channel classification for the interaction
interaction_at	TIMESTAMP	Timestamp when the interaction occurred

Your question is SQL For Marketing Touchpoints. 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