Strict Match on Many-to-One Relationships in Lookup Tables Using SQL

How to Query Contracts Without Specific Type Names Using NOT EXISTS Clause.