Practice · easy · dataset: ecom

Catalog page two

The catalog is paged five rows at a time, ordered by unit price descending and then by product_id ascending. Return the second page, which is rows six through ten of that ordering.

Return product_id, name, and unit_price. Keep the same ordering as the full catalog.

Tables available

Table Columns
products product_id, name, category, unit_price

Do not filter the catalog first; page two is defined over the complete product list.

⌘/Ctrl + Enter to grade

Write a query, then grade it.

Hints

Try it first. Reveal a hint only when you are stuck.