在SQL Server中，为产品表选择适当的查询，其中数据应主要按ProductGroup列的升序显示。二级排序应按CurrentStock列的降序进行。( )
Select * from Products order by CurrentStock,ProductGroup
Select * from Products order by CurrentStock DESC,ProductGroup
Select * from Products order by ProductGroup,CurrentStock
Select * from Products order by ProductGroup,CurrentStock DESC
都不对
