SELECT specific columns from a dimension table, filtered by a text value
We're reviewing our TL network. Pull `lane_id`, `origin_region`, `dest_region`, and `distance_miles` from `dim_lanes` for TL lanes only, sorted by `distance_miles` descending. I need to see the longest hauls first.
| Column | Type | Key |
|---|---|---|
| lane_id | INT | PK |
| origin_region | TEXT | |
| dest_region | TEXT | |
| distance_miles | INT | |
| transit_days_target | INT | |
| mode | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
TL is one of the freight modes — narrow the lanes down to that single mode.
Distance lives on dim_lanes; you want longest first.
No JOIN needed — dim_lanes already has every column the brief lists.