Solve the business requirement using SOQL. Return meaningful records or aggregate groups for the supplied data.
Use the SOQL features specified in the tags and preserve the required filters and ordering.
1 row(s), any order
| # | Id | Name | Cases |
|---|---|---|---|
| 1 | 001000000000001AAA | Account 1 | [2 records] |