|As executed and displayed in SQLiteSpy.|
This small query returns a list of named groups with the total number of people in each group.
It also includes the GroupID number which may be useful for inspecting the GroupTable.
It creates a temporary View which is dropped when the SQLite manager closes the database.
It requires the RMNOCASE collation.
It is very fast. On a database of some 1200 people and 40 named groups, it takes around 8 milliseconds to the results in the screenshot. On a database of 160,000 and 3 groups, just 1/3 second.