选择一个变量不会在组中的另一个变量中共同出现的观察结果（SQL）

I'm working with the patents-public-data.patents.publications_201710 table in Google's BigQuery. My goal is to identify potential corporate-owned patents. Since an inventor must be an individual and not a corporation, I can theoretically do so by identifying records where the assignee is not found in the list of inventors. The tricky part is that there are often multiple inventors and even multiple assignees for the same publication_number.I'm working with the patents-public-data.patent