Finance Path · Mission 2 of 25Starter

Who owns which cost center?

SELECT specific columns (not SELECT *)

Back to Finance

The Brief

Mei LinFP&A Managerfpna

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.

You'll practice

SELECTExploration

Tables available

dim_cost_centers

Hints (3)

Each hint you reveal reduces the XP you can earn. Try the query first.

Hint 1

`dim_cost_centers` has 8 rows and more columns than we need. Select only the three Mei asked for.

Hint 2

No WHERE clause needed — she wants every cost center.

Hint 3

`SELECT cost_center_name, department, owner_email FROM dim_cost_centers`.