Read a dimension table and apply a simple WHERE filter + LIMIT. dim_shoppers is the gig courier roster; practice previewing a subset of columns for active shoppers only.
I'm onboarding a new dispatcher and want them to eyeball the active roster. Give me the first 20 active shoppers: shopper_id, shopper_name, vehicle_type, home_zone. Only status = 'active'. ORDER BY shopper_id ASC, LIMIT 20.
| Column | Type | Key |
|---|---|---|
| shopper_id | INT | PK |
| shopper_name | TEXT | |
| home_zone | TEXT | |
| vehicle_type | TEXT | |
| signup_date | TEXT | |
| last_active_date | TEXT | |
| status | TEXT | |
| rating | REAL |
Each hint you reveal reduces the XP you can earn. Try the query first.
dim_shoppers is the only table you need here.
Filter with WHERE status = 'active', then select the four columns asked for.
ORDER BY shopper_id ASC and cap the output with LIMIT 20.