Question:Select the appropriate query for the Products table when data should be primarily ordered by ProductGroup. ProductGroup should be displayed in ascending order and CurrentStock should be in descending order:
A Select * from Products order by CurrentStock,ProductGroup
B Select * from Products order by CurrentStock DESC,ProductGroup
C Select * from Products order by ProductGroup,CurrentStock
D Select * from Products order by ProductGroup,CurrentStock DESC
E None of these above
+ AnswerD
+ Report