with check_countries as (SELECT count(distinct country_region)FROM `bigquery-public-data.covid19_jhu_csse.summary` LIMIT 1000),Hu_filter as (select 'HU' as country, * from `bigquery-public-data.covid19_jhu_csse.summary`where upper(country_region) = 'HUNGARY'),filtered as (select date, confirmed,…

with generate_months as (SELECT * FROM UNNEST(GENERATE_DATE_ARRAY('2020-01-01', '2021-12-1', INTERVAL 1 MONTH)) AS dates) select 1 as key, left(cast(dates as string),7) as yearmonthfrom generate_months