Sort Products — Solution & ExplanationProblems / Sort Products / EditorialApproachORDER BY controls the row order of your result set.

SELECT the three columns.

ORDER BY category ASC groups products alphabetically by category.

price DESC as the second sort key puts the most expensive item first within each category.

Multi-column sorting is essential when you need a primary and secondary sort order.Hints

ORDER BY accepts multiple columns separated by commas.

Use ASC for ascending (default) and DESC for descending order.

In PySpark, use .asc() and .desc() on column objects inside .orderBy().