CODE EXAMPLE FOR SQL

salesforce soql get parents without children

SELECT Id, Name FROM Account WHERE Id NOT IN (SELECT AccountId FROM Opportunity)