Challenge
Write a query to find and return every account having an average opportunity amount of less than 50,000.
Return the AccountId and use the alias avgAmount
to represent the average amount.
Return the results sorted in any order.
The result format is in the following example:
AccountId | avgAmount |
---|---|
0014x00000SExyzAAB | 5889.12 |
0014x00000SESBfAAP | 7983.33 |
0014x00000SEPOLBBX | 49999.99 |