COUNT — peek at the supplier dim and produce a single scalar.
Welcome aboard. Before our supplier review on Friday, just give me a head-count: how many suppliers are in `dim_suppliers`? One number. Nothing fancy.
| Column | Type | Key |
|---|---|---|
| supplier_id | INT | PK |
| supplier_name | TEXT | |
| country | TEXT | |
| lead_time_target_days | INT | |
| on_time_target_pct | REAL | |
| is_active | INT |
Each hint you reveal reduces the XP you can earn. Try the query first.
There's exactly one table you need: `dim_suppliers`.
Maya wants a count, not the rows themselves. Reach for `COUNT(*)`.
The full query is `SELECT COUNT(*) FROM dim_suppliers`. One column, one row.