Solve the business requirement using SOQL.
Return the requested records or aggregate groups, preserving the required filters and ordering.
Use the SOQL features named in the tags. Return the required fields and ordering.
5 row(s), any order
| # | Id | Name | Opportunities |
|---|---|---|---|
| 1 | 001000000000001AAA | Account 1 | [1 record] |
| 2 | 001000000000002AAA | Account 2 | [1 record] |
| 3 | 001000000000003AAA | Account 3 | [1 record] |
| 4 | 001000000000004AAA | Account 4 | [1 record] |
| 5 | 001000000000005AAA | Account 5 | [1 record] |