SQL · Snowflake · Medium
We have two tables that track marketing interactions and contact details. Table: events Column Name Type event_id integer contact_id integer event_type varchar(255) event_date date Table: contacts Column Name Type contact_id integer email varchar(255) event_id uniquely identifies each row in the events table. contact_id is a unique identifier for a person across both tables. Write a query that finds every contact who satisfies both of these rules: Their marketing activity…
Checking your access…