Query Activity - Day 1 focused Resource

Write a query activity to find weekdays, when subscribers likely opens email in last 30 days

SELECT
SubscriberKey,
CASE 
WHEN s.WEEKDAY=0 THEN 'MONDAY'
WHEN s.WEEKDAY=1 THEN 'TUSEDAY'
WHEN s.WEEKDAY=2 THEN 'WEDNESDAY'
WHEN s.WEEKDAY=3 THEN 'THURSDAY'
WHEN s.WEEKDAY=4 THEN 'FRIDAY'
WHEN s.WEEKDAY=5 THEN 'SATURDAY'
WHEN s.WEEKDAY=6 THEN 'SUNDAY'
END
AS LIKELYOPENSON
FROM
(SELECT MAX(DATEPART(WEEKDAY, EventDate)) AS WEEKDAY,SubscriberKey from _Open
WHERE EventDate >= DATEADD(day, -30, GETDATE())
group by SubscriberKey) s
WHERE SubscriberKey IN (SELECT SubscriberKey FROM MasterDE)         

Write a query activity to find how many emails were send per second for JobID=1234

select
? ? ? ?count(SubscriberKey)
? ? ? ?,convert(varchar, EventDate, 20) as EventDate
? ? ? ?,JobID
from _sent
where JobID=1234 
group by EventDate,JobID        

Write a query activity to find all the activities associated with Journey ='Journey1'

Select 
? ActivityName
, ActivityID
, JourneyActivityObjectID
, ActivityType
, ActivityExternalKey, 
_JourneyActivity.VersionID
,JourneyName
from _JourneyActivity inner join _Journey on
_JourneyActivity.VersionID=_Journey.VersionID
where JourneyName='Journey 1'