The correct option should be ORDER BY ProductCategoryID ASC, ListPrice DESC I've ran the code and option 3 fits the requirement more with the added sorting from ProductCategoryID ASC \m/