Find Accounts with more than one Opportunity
Not Started

Challenge

Write a query to find every account that has more than one Opportunity. Return the AccountId and use the opportunityCount alias to represent the number of opportunities for that account.

Return the results sorted by the opportunity count in descending order.

The result format is in the following example:

AccountIdopportunityCount
0014x00000SExyzAAB8
0014x00000SESBfAAP5
0014x00000SEPOLBBX2