MySQL SELECT Queries: Sorting Data

Sort Employees by Hire Date Descending

Write a query to list employees sorted by their hire date from newest to oldest.

Expected output: Employees listed with the most recently hired first.

Hint: Use ORDER BY with DESC on the hire_date column.

Sort Products by Category and Price

Write a query to sort products first by category ascending, then by price descending.

Expected output: Products grouped by category alphabetically, with expensive items first within each category.

Hint: Use ORDER BY with two columns and specify ASC and DESC accordingly.

You use the ORDER BY clause in a SELECT statement to sort results by one or more columns in ascending (ASC) or descending (DESC) order.

The default sort order is ascending (ASC) if neither ASC nor DESC is specified.

Yes, you can specify multiple columns in the ORDER BY clause to sort data hierarchically.