Challenge
Write a query that returns the total number of contacts associated with each account.
The records should be grouped by the Account's Name.
Assign the alias contactCount for the column representing the total number of contacts for that account.
The query should return the Account's Name and contactCount.
Return the results in any order
The result format is in the following example:
| Account.Name | contactCount |
|---|---|
| Willis-Phillips LLC | 2 |
| Attar-Doogle Corp | 5 |