What you are looking for is too fancy for this table resource. It just displays rows and columns - it is not sophisticated enough to promote repeated values up to group headers.
Group By as a sql/swql command is not the same kind of thing as the Group By that is available in the Orion Report Builder. SQL/SWQL queries dont support that kind of capability as they always present their output in flat lists. You can try to push this query into an Orion Report/Table without the ordering and grouping and then take advantage of that tool's Group By, but I find that it can get kind of cranky in terms of what it will and won't accept as a custom query input. Lots of things that I've tried will work in the SWQL Studio/Custom Query web resource but get rejected when I try to use them as a source for the report/table tools.
Loop1 Systems: SolarWinds Training and Professional Services