Câu 77: Certified Platform Developer II

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 will return a unique list of all the Contact records that have no `˜Fulfilled' Orders?

1. A. SELECT Id FROM Contact WHERE Id NOT IN (SELECT Id FROM Order__c WHERE Status__c = 'Fulfilled')
2. B. SELECT Contact__c FROM Order__c WHERE Status__c <> 'Fulfilled'
3. C. SELECT Id FROM Contact WHERE Id NOT IN (SELECT Contact__c FROM Order__c WHERE Status__c = 'Fulfilled')
4. D. SELECT Contact__c FROM Order__c WHERE Id NOT IN (SELECT Id FROM Order__c Where Status__c = 'Fulfilled') — đáp án hiện tại