COVID NEW CASES HU daily 2021.09.21-2021.10.20
select *from (select country_region, date, confirmed, deaths,LAG(confirmed, 1) OVER (PARTITION BY country_region ORDER BY date ASC) AS prev_day,confirmed - LAG(confirmed, 1) OVER (PARTITION BY country_region ORDER BY date ASC) as new_casesfrom `bigquery-public-data.covid19_jhu_csse.summary`WHERE…