I will explain clearly :
I have hockey stats in a table by position

Player 12 :  

```
StatsID  /  PlayerID   / Position  / gamesPlayed / points  /  Season
 1      /     12      /  RW     /      40     /  32     / 2013-2014
 2      /     12     /  Def    /       1     /   1    / 2013-2014 

```

So I want a query like this  

```
Select PlayerID , Season , sum(gamesPlayed) as GP, sum(points) as pts , ???? from
MyPointTable GROUP BY PlayerID, SEASON

```

I want to replace my ???? that will gives me the position that the played play the most so he play 40 games like a RW . I can't count , I can't sum. 

The SQL result is supposed to gives   

```
ID , Season    , GP , pts, MostPosition
12 , 2013-2014 , 41 , 33 , RW

```

Thanks