Sort first, then keep the rows you need.

1. The 5 most recent orders, newest first: id, then order_date.
2. Page 2 of the customer list, with 4 customers per page, sorted by name: id, then name.
3. The newest hire in department 2 (Support): name, then hired_on.
4. Think before you run it: how many rows does SELECT * FROM products ORDER BY id LIMIT 5 OFFSET 10; return?