Compute new cases for each day.

To account for "administrative weekends" with fewer reports or missing data, compute the smoothed rolling average between two preceding days and two following days.

Fetch latest available per state data from statistics. Note that states may have different latest submission dates. $($hint: ROW$\_$NUMBER$())$

Use the "latest data" derived from the above query and demographic information to compute the mortality per $100,000$ population.

Find the biggest spike in new deaths per country. Sort them by the most recent date, then by the count of new deaths. $($hint: RANK$())$