s.SubscriberKey,
s.JobID,
s.BatchID,
convert(char(19),s.EventDate,20) as SendDate
from [_sent] s
left join [_open] o
on s.JobID = o.JobID and s.ListID = o.ListID and s.BatchID = o.BatchID and s.SubscriberID = o.SubscriberID and o.IsUnique = 1
where
s.JobID = JobID
and o.SubscriberID is NULL```

I am having trouble to get the JobId from the original email sent and fill it in the query.

Can some one guide / help me in this Mkt Cloud issue.