DISTINCT EVENT_DATA:id :: STRING AS "ID",

CASE

WHEN EVENT_DATA:seriesID :: STRING = '1' THEN '2023'

WHEN EVENT_DATA:seriesID :: STRING = '2' THEN '2024'

WHEN EVENT_DATA:seriesID :: STRING = '3' THEN '2024'

WHEN EVENT_DATA:seriesID :: STRING = '4' THEN '2025'

ELSE EVENT_DATA:seriesID :: STRING

END AS "Series",

EVENT_DATA:editionType AS "Edition Type",

EVENT_DATA:name AS "Set Name"

flow.core.fact_events

EVENT_CONTRACT = 'A.edf9df96c92f4595.Pinnacle'

AND EVENT_TYPE = 'SetCreated'

ORDER BY

CAST("ID" AS INTEGER), "ID" ASC;