I am a novice when it comes to SQL. I'm trying to identify all records in Marketing Cloud that are not part of an active journey (ie. they have never been a member of one or have exited one in the past). I see there is a Data View for Journeys, which is probably useful here.
Would it possible to query the Journey table with logic something like: show all Leads & Contacts not in any Journey or member status of Journey is not Active? If so, what would that need to look like? Would I need to list out all Journey Names or could I group all names with a Where clause like "contains "Journey" in the name"?