Question 1
(Topic 1)
A developer needs to identify all subscribers who were sent Job ID 420 but did not click any links. Which SQL statement would produce the desired results?
Select an option, then click Submit answer.
- ○ SELECT s.SubscriberKey - FROM _Sent s - JOIN _Click c ON s.SubscriberKey = c.SubscriberKey AND s.JobID = c.JobID WHERE s.JobID = 420
- ○ SELECT s.SubscriberKey - FROM _Sent s - LEFT JOIN _Click c ON s.SubscriberKey = c.SubscriberKey AND s.JobID = c.JobID WHERE s.JobID = 420
- ○ SELECT s.SubscriberKey - FROM _Sent s - LEFT JOIN _Click c ON s.SubscriberKey = c.SubscriberKey AND s.JobID = c.JobID WHERE s.JobID = 420 AND c.SubscriberKey IS NULL
