Which SOQL query wrii return a unique list of all the Contact records that have no Fulfilled Orders?

A company has a custom object. Order__c, that has a custom picklist field. Status__c, with values of New, In Progress," or Fulfilled and a lookup field, Contact_c, to Contact.

Which SOQL query wrii return a unique list of all the Contact records that have no Fulfilled Orders?
A . SELECT Contact_c From order_c Where id NOT IN (SELECT id FROM_c Where States_c + Fulfilled’)
B . SELECT iD FROM Contact WHERE id NOT IN (SELECT id From order_c WHERE_c = Fulfilled’)
C . SELECT Contact_c FROM Order_c Where Status_c <> ;Fulfilled’
D . SELECT id FROM Contact WHERE id NOT IN (SELECT Contact _c FROM order_c Where Status_c = fulfilled’)

View Answer

Answer: D