As a marketing analyst at ABC Corporation, I want to retrieve a list of all the Accounts associated with Contacts whose email addresses contain "@gmail.com" so that I can target these customers with a tailored marketing campaign.
List<Account> accounts = [SELECT Id, Name FROM Account WHERE Id IN (SELECT AccountId FROM Contact WHERE Email LIKE '%@gmail.com%')];