Derive Insights from BigQuery Data: Challenge Lab Reviews

Nicola K. · Reviewed about 1 month ago

Richard C. · Reviewed about 1 month ago

Richard C. · Reviewed about 1 month ago

Yasuhiro A. · Reviewed about 1 month ago

Eka P. · Reviewed about 1 month ago

Richard C. · Reviewed about 1 month ago

Ezequiel R. · Reviewed about 1 month ago

Nicolas O. · Reviewed about 1 month ago

Osmin L. · Reviewed about 1 month ago

NIPUN P. · Reviewed about 1 month ago

Dmytro L. · Reviewed about 1 month ago

Ruben C. · Reviewed about 1 month ago

Ihor S. · Reviewed about 1 month ago

Juveriya N. · Reviewed about 1 month ago

Narendar Y. · Reviewed about 1 month ago

Madhavi A. · Reviewed about 1 month ago

Sergiy Y. · Reviewed about 1 month ago

abhik d. · Reviewed about 1 month ago

Genom G. · Reviewed about 1 month ago

Vignesh M. · Reviewed about 1 month ago

Shreyashkumar L. · Reviewed about 1 month ago

Sohan S. · Reviewed about 1 month ago

Cameron J. · Reviewed about 1 month ago

Simran S. · Reviewed about 1 month ago

My Task-4 query was giving the correct results, yet the task progress was not being recorded. I had to write in a completely different way, which wasted a lot of time - select subregion1_name as state, confirmed_count as total_confirmed_cases from (select subregion1_name, sum(cumulative_confirmed) confirmed_count from bigquery-public-data.covid19_open_data.covid19_open_data where date = '2020-04-25' and country_name = 'United States of America' and cumulative_confirmed is not null and subregion1_name is not null group by subregion1_name) where confirmed_count >2000 ORDER BY total_confirmed_cases DESC ;

Gaurav M. · Reviewed about 1 month ago