SOQL for all accounts without opportunities
One of those typical interview questions is:
Can you write a SOQL to fetch a list of accounts which do not have any opportunities associated with them?
The answer is YES and the SOQL looks something like this