COVID Cases Hungary
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…