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.