SELECT specific columns (not SELECT *)
Priya wants to send the month-end variance reports to cost center owners. Can you pull `cost_center_name`, `department`, and `owner_email` from `dim_cost_centers`? All of them — I'll paste it into the distribution list.
| Column | Type | Key |
|---|---|---|
| cost_center_id | INT | PK |
| cost_center_code | TEXT | |
| cost_center_name | TEXT | |
| department | TEXT | |
| owner_email | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Everything Mei needs is in a single table. She only wants three of the available columns — name them explicitly rather than pulling everything.
No WHERE clause needed — she wants every cost center.
Pull three specific columns from dim_cost_centers: the center's name, its department, and the owner's email address.