duplicate - Group By

Giganews Newsgroups
Subject: duplicate - Group By
Posted by:  learning_cod…@hotmail.com (learning_cod…@hotmail.com)
Date: Wed, 11 Mar 2009


I'm having a trouble understanding how to use a group by total.

I have many duplicates but want to group by total.

I have right now and see below.

Sport      # of players
Hockey        20
Hockey        10
Hockey        13

Baseball        10
Baseball        4

I want to see like this:

Sport        # of players
Hockey          43
Baseball          14

Your help would be much appreciated.