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?
A.
SELECT s.SubscriberKey -
FROM _Sent s - JOIN _Click c ON s.SubscriberKey = c.SubscriberKey AND s.JobID = c.JobID WHERE s.JobID = 420
B.
SELECT s.SubscriberKey -
FROM _Sent s - LEFT JOIN _Click c ON s.SubscriberKey = c.SubscriberKey AND s.JobID = c.JobID WHERE s.JobID = 420
C.
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
CaesarLuffy
2 months, 3 weeks ago