Derive Insights from BigQuery Data: Challenge Lab Reviews

Fiz o script da etapa 5 e não consta como certo. tentei das 2 formas e não consigo passar a etapa. select min(date) as dia from ( select distinct date from `bigquery-public-data.covid19_open_data.covid19_open_data` where country_name = 'Italy' and cumulative_deceased >= 16000 ) ou esse select min(date) as dia from ( select distinct date,sum(cumulative_deceased)cumulative_deceased from `bigquery-public-data.covid19_open_data.covid19_open_data` where country_name = 'Italy' group by date ) where cumulative_deceased >= 16000

BRUNA R. · Reviewed 4 months ago

Novan N. · Reviewed 4 months ago

Arif T. · Reviewed 4 months ago

Grzegorz c. · Reviewed 4 months ago

Bharath Kumar A. · Reviewed 4 months ago

Suresh D. · Reviewed 4 months ago

George W. · Reviewed 4 months ago

Ankush A. · Reviewed 4 months ago

Suresh S. · Reviewed 4 months ago

Vraj P. · Reviewed 4 months ago

Saba B. · Reviewed 4 months ago

This lab is abysmal. Why do you need to run a bigquery for the final task? It does not say this at all, and making the correct report in looker studio isn't sufficient unless you run an unrelated query. You can get the correct results for the other tasks, but unless the SQL is specifically as expected then you don't complete the task - for example changing the names of the subquerys in the 'india cases' task means you don't get the tick. Awful waste of time

Joe P. · Reviewed 4 months ago

Parvathidevi G. · Reviewed 4 months ago

Rifai N. · Reviewed 4 months ago

achraf i. · Reviewed 4 months ago

Ambuj S. · Reviewed 4 months ago

fitra s. · Reviewed 4 months ago

usamah G. · Reviewed 4 months ago

Leslie W. · Reviewed 4 months ago

Laxmi T. · Reviewed 4 months ago

Moh. S. · Reviewed 4 months ago

Anne J. · Reviewed 4 months ago

add more query image solution

Ahmad A. · Reviewed 4 months ago

Telma N. · Reviewed 4 months ago

Regis Gurgel S. · Reviewed 4 months ago