Getting Fancy With a Select Based on A List (IN)

Here the list was created by a Sub-query to only show Missions that included at least 1 life form

Sub-Query