import pandas as pd

df_vaccines = pd.read_csv('https://onemocneni-aktualne.mzcr.cz/api/v2/covid-19/ockovani.csv') df_vaccines

SELECT datum, SUM(prvnich_davek) as prvnich_davek FROM df_vaccines WHERE vekova_skupina IN ('70-74', '75-79') -- age group 70-79 AND datum > '2021-03-01' -- date after March 1, 2021 GROUP BY datum ORDER BY datum

SELECT *, -- let's do a cumulative sum of first_shot (prvnich_davek) SUM(prvnich_davek) OVER(ORDER BY datum ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative FROM df_vaccines_sorted