SELECT all columns from a dimension table, sorted by a text column
I'm building the carrier directory for our ops deck. Pull all 8 carriers from `dim_carriers` — every column — sorted alphabetically by `carrier_name`. I want to see mode, SCAC code, target OTD, and HQ state for each one.
| Column | Type | Key |
|---|---|---|
| carrier_id | INT | PK |
| carrier_name | TEXT | |
| scac | TEXT | |
| mode | TEXT | |
| on_time_target_pct | REAL | |
| hq_state | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Single-table query — `dim_carriers` is the dimension, no JOIN needed. Project all columns.
Sort the result by `carrier_name` ascending — that's the default direction for ORDER BY.
No WHERE filter — all 8 carriers should appear in the output.