The support manager needs a dashboard tile showing how many open cases exist per priority.
Return one row per Priority with the number of Cases whose Status is not 'Closed'. Alias the count as total. Sort by Priority ascending.
| Priority | total |
|---|---|
| High | 42 |
| Low | 17 |
COUNT(Id)), aliased total.3 row(s), order checked
| # | total | Priority |
|---|---|---|
| 1 | 24 | High |
| 2 | 24 | Low |
| 3 | 24 | Medium |