Insights from Data with BigQuery: Challenge Lab
The query that I did works however it doesn't account anything, I assume that I need to queries using WITH clause.
In the Query 4: Fatality Ratio the check my progress box is wrong - as the total cases in April is equal to the sum of cumulative confirmed cases in all regions in Italy at the end of the month, whereas the query is accepted only if you sum cumulative confirmed cases for all days in the month - which is really frustrating as it literally requires you to look for errors in a proper query.
Try scoring the lab based on the output rather than just checking out if certain key words are present in the query. Pretty shameful on this aspect considering this is coming from an organisation I look up to.
should have been an example of output expected, because my result set is correct but I don't pass on the checkpoint progress because it expects EXACTLY the query the the course wants it.