SQL Server查询 一个字段中不同值在另一个字段中分别出现的总个数，总个数从打到小排序？

GoodsID  Num
A         4
B         2
C         1
A         3
B         4
C         3

我想得到：

GoodsID   Count
A          7
B          6
C          4

用SQL Server语句如何实现？恳请行家高手不吝惜指点！万分感谢！！

select GoodsID, sum(Num) as Count from table
group by GoodsID

    SELECT GoodsID, SUM(Num) AS [Count]
      FROM table1
     GROUP BY GoodsID
     ORDER BY [Count] DESC

select sum(Num) as [Count], GoodsID from table group by GoodsID
order by [Count] desc
要加上方括号，Count是关键字

我的回答哪里去了。明明我第一个回答的，怎么删了？

select sum(Num) as Count, GoodsID from table group by GoodsID
2015.05.28 17:16

   SELECT GoodsID, SUM(Num) AS [Count]
      FROM table
     GROUP BY GoodsID
     ORDER BY [Count] DESC

SELECT GoodsID, SUM(Num) AS [Count]
FROM table1
GROUP BY GoodsID
ORDER BY [Count] DESC

SELECT GoodsID ,sum(Num) Count
FROM table
GROUP BY GoodsID
ORDER BY [Count]DESC;

非常感谢大家的慷慨解答！我还有一个问题要补充：
我想从另外一个表中（GoodsInfo）获得GoodsName，和“select sum(Num) as [Count], GoodsID from OrderInfo group by GoodsID order by [Count] desc”
查询到的结果组合成一个表。如何实现呢？
两个表都有共同字段GoodsID，即实现下表所示：

GoodsID  Num
A         4
B         2
C         1
A         3
B         4
C         3

我想得到：

GoodsID   GoodsName   Count
A                         a                7
B                         b                6
C                         c                4

用SQL Server语句如何实现？恳请行家高手不吝惜指点！万分感谢！！

 SELECT Sum(Num) AS Count, GoodsID FROM Table GROUP BY GoodsID

select sum(OrderInfo.Num) as [Count], OrderInfo.GoodsID, Max(GoodsInfo.Name) as [Name] from OrderInfo join GoodsInfo on GoodsInfo.id = OrderInfo.GoodsID group by OrderInfo.GoodsID order by OrderInfo.[Count] desc

 select sum(Num) as [Count], GoodsID, GoodsName 
 from OrderInfo,GoodsInfo where OrderInfo.GoodsID = GoodsInfo.GoodsID
 group by GoodsID order by [Count] desc