I suspect your definition of 'group by' might be different than mine. Using the sample data in your first post how would the resultset look if it did a "Group By inside each Select"?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato