How do I get a count on the sum of the number of different GroupId's in the table below. The table is just an example.
So for the sample table below the query would produce values of 3,2,1
Because there a 3 records with GroupID of 1, two with GroupId of 2, and 1 for GroupID of 3
Table Name is "Teams"