I'm trying to confirm that the query I have written is correct. I'm trying to pull back people from the 3 lists in the query that have not opened an email within the last 6 months to start a re-engagement/inactive campaign. Also, can Salesforce look past 6 months if I wanted to do the same for clicks? Thanks! (Note - we use subscriber key as email)

SELECT distinct SubscriberKey FROM _Sent WHERE EventDate > dateadd(day, -180, getdate()) AND SubscriberKey NOT IN ( SELECT SubscriberKey FROM _Open WHERE EventDate > dateadd(day, -180, getdate()) ) AND ListID IN ('3672' , '3673' , '3671')