Demand Planning & Forecasting Analytics · Mission 3 of 30Starter

Forecast versions

SELECT all from a dimension sorted

The Brief

Lena ParkDemand Planning Managerdemand-planning

Pull all forecast versions sorted by lock_date. Show version_id, version_name, lock_date.

You'll practice

ORDER BY

Tables & columns available

dim_forecast_versionsdim4 columns
ColumnTypeKey
version_idINTPK
version_nameTEXT
lock_dateTEXT
horizon_weeksINT

Hints (3)

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

Hint 1

Single-table SELECT.

Hint 2

ORDER BY lock_date.

Hint 3

Three columns.