I am trying to write a single query to get an account record and the count of contacts for the account. Can this be done?
Ex:
SELECT Name,Id,BillingState, (SELECT count() FROM Contact Where Contact.AccountID = Id) FROM Account WHERE Name like '%Test%'"
Thank You
Dakota
