下面在sh_goods表中根据cat_id升序排序,并对每个cat_id按price降序排序的语句是()。 A: SELECT*FROMsh_goodsORDERBYpriceDESC,cat_id; B: SELECT*FROMsh_goodsORDERBYprice,cat_id; C: SELECT*FROMsh_goodsORDERBYcat_id,priceDESC; D: SELECT*FROMsh_goodsORDERBYcat_idDESC,price;