WITH crv_schedule AS ( SELECT * ,total_liq_incentives + total_early_users + total_core_team + total_investors + total_employees + total_reserve AS total_supply ,liq_incentives + early_users + core_team + investors + employees + reserve AS daily_emissions FROM ( SELECT * ,SUM(liq_incentives) OVER(ORDER BY time) AS total_liq_incentives ,SUM(early_users) OVER(ORDER BY time) AS total_early_users ,SUM(core_team) OVER(ORDER BY time) AS total_core_team ,SUM(investors) OVER(ORDER BY time) AS total_investors ,SUM(employees) OVER(ORDER BY time) AS total_employees ,SUM(reserve) OVER(ORDER BY time) AS total_reserve FROM ( SELECT time ,CASE WHEN time <= '2021-08-13' THEN 752918.583561644 -- year 1 WHEN time <= '2022-08-13' THEN 633126.537894891 -- year 2 WHEN time <= '2023-08-13' THEN 532393.836117809 -- year 3 WHEN time <= '2024-08-13' THEN 446464.876851211 -- year 4 WHEN time <= '2025-08-13' THEN 376459.291780822 -- year 5 WHEN time <= '2026-08-13' THEN 316563.268947446 -- year 6 WHEN time <= '2027-08-13' THEN 266196.918058904 -- year 7 WHEN time <= '2028-08-13' THEN 223232.438425606 -- year 8 WHEN time <= '2029-08-13' THEN 188229.645890411 -- year 9 WHEN time <= '2030-08-13' THEN 158281.634473723 -- year 10 ELSE 133098.459029452 --CODE WILL BREAK ON 2031-08-15 END AS liq_incentives ,CASE WHEN time <= '2021-08-13' THEN 415110.00436772 -- year 1 ELSE 0 END AS early_users ,CASE WHEN time <= '2021-08-13' THEN 548603.529712329 -- year 1 WHEN time <= '2022-08-13' THEN 548603.529712329 -- year 2 WHEN time <= '2023-08-13' THEN 548603.529712329 -- year 3 WHEN time <= '2024-08-13' THEN 547104.612964481 -- year 4 ELSE 0 END AS core_team ,CASE WHEN time <= '2021-08-13' THEN 148122.953027397 -- year 1 WHEN time <= '2022-08-13' THEN 148122.953027397 -- year 2 ELSE 0 END AS investors ,CASE WHEN time <= '2021-08-13' THEN 124533.001310316 -- year 1 WHEN time <= '2022-08-13' THEN 124533.001310316 -- year 2 ELSE 0 END AS employees ,CASE WHEN time <= '2021-08-13' THEN 415110.00436772 -- year 1 ELSE 0 END AS reserve FROM ( SELECT dateadd(day, '-' || seq4(), '2030-08-14') as time FROM table(generator(rowcount => 3653) ) ) sub1 ) sub2 ),