SELECT
Max(EventDate) as Eventdate,
IsUnique,
SubscriberKey,
SubscriberID
  FROM _open o
  JOIN _Job j on j.jobid = o.jobid
  WHERE eventdate >= DATEADD(dd,-1,getdate())
  AND EmailName = 'EW01 welcome email'