CASE

WHEN DATEDIFF('month', CURRENT_TIMESTAMP, UNLOCK_TIMESTAMP) <= 3 THEN '0-3 Months'

WHEN DATEDIFF('month', CURRENT_TIMESTAMP, UNLOCK_TIMESTAMP) BETWEEN 4 AND 6 THEN '4-6 Months'

WHEN DATEDIFF('month', CURRENT_TIMESTAMP, UNLOCK_TIMESTAMP) BETWEEN 7 AND 12 THEN '7-12 Months'

WHEN DATEDIFF('month', CURRENT_TIMESTAMP, UNLOCK_TIMESTAMP) BETWEEN 13 AND 24 THEN '1-2 Years'

WHEN DATEDIFF('month', CURRENT_TIMESTAMP, UNLOCK_TIMESTAMP) BETWEEN 25 AND 36 THEN '2-3 Years'

ELSE '3+ Years'

END AS maturity_period,

SUM(OLAS_AMOUNT) AS "veOLAS Amount",

CASE

WHEN DATEDIFF('month', CURRENT_TIMESTAMP, UNLOCK_TIMESTAMP) <= 3 THEN 1

WHEN DATEDIFF('month', CURRENT_TIMESTAMP, UNLOCK_TIMESTAMP) BETWEEN 4 AND 6 THEN 2

WHEN DATEDIFF('month', CURRENT_TIMESTAMP, UNLOCK_TIMESTAMP) BETWEEN 7 AND 12 THEN 3

WHEN DATEDIFF('month', CURRENT_TIMESTAMP, UNLOCK_TIMESTAMP) BETWEEN 13 AND 24 THEN 4

WHEN DATEDIFF('month', CURRENT_TIMESTAMP, UNLOCK_TIMESTAMP) BETWEEN 25 AND 36 THEN 5

ELSE 6

END AS sort_order

FROM crosschain.olas.ez_olas_locking

WHERE UNLOCK_TIMESTAMP > CURRENT_TIMESTAMP -- Only future unlocks

GROUP BY maturity_period, sort_order

ORDER BY sort_order