First contact with dim_listings — the marketplace seller's product catalog. Practice single-table SELECT with column projection, WHERE filter on a status column, ORDER BY, and LIMIT for pagination. Foundational shape every marketplace analyst writes daily.
Welcome to the marketplace ops team. Before we touch a single dashboard, get familiar with our listings catalog. From dim_listings, pull the first 10 active listings (current_status = 'active') ordered by listing_id ascending. Four columns: listing_id, product_title, category, list_price. Sanity-check the output — every active listing should have a non-zero list_price and a category that maps to one of our six bucket categories.
| Column | Type | Key |
|---|---|---|
| listing_id | INT | PK |
| marketplace_id | INT | FK → dim_marketplaces |
| asin_or_listing_id | TEXT | |
| product_title | TEXT | |
| category | TEXT | |
| list_price | REAL | |
| current_status | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Single-table query — dim_listings is the only one you need.
Filter on current_status = 'active' to exclude paused and delisted listings.
ORDER BY listing_id ASC keeps the output deterministic across reruns.
LIMIT 10 caps the output — pagination idiom for catalog views.