Find all Accounts which do not have any open opportunities

Select Id, Name From Account Where Id NOT IN (SELECT AccountId FROM Opportunity)