COVID monthly NEW cases HU
and monthly confirmed cases total
with data_21 as (select * from (select country_region, date as date_21, confirmed as confirmed_21, deaths as deaths_21,LAG(confirmed, 1) OVER (PARTITION BY country_region ORDER BY date ASC) AS prev_day_21,confirmed - LAG(confirmed, 1) OVER (PARTITION BY country_region ORDER BY date ASC) as…