COVID NEW CASES HU daily 2021.08.01-2021.09.21
select *from (select country_region, date, confirmed, deaths, recovered, active,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…
