SQL practice: ORDER BY, LIMIT and OFFSET

List all customers sorted by city A→Z.

List the 5 cheapest products.

List all employees from highest paid to lowest.

List products sorted by category A→Z, and within each category by price high→low.

Show the products ranked 4th to 6th most expensive.

Show the 3 most recent orders.

Show the 5 oldest customers by signup_date. What happens to Nova Interiors, whose date is empty?

Show the single most profitable product per unit (price minus cost).

If a web page shows 4 products per page, write the query for page 3, sorted by name A→Z.

Show the 3 most expensive products, priciest first. This query returns the 3 cheapest instead. Fix it.