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…