Derive Insights from BigQuery Data: Challenge Lab Reviews

I spent more than an hour on Item 2 and couldn’t get any further. SELECT count( distinct subregion1_name) AS count_of_states FROM `bigquery-public-data.covid19_open_data.covid19_open_data` WHERE country_name = 'United States of America' AND subregion1_name IS NOT NULL AND cumulative_deceased IS NOT NULL AND cumulative_deceased > 100 AND date = '2020-06-25'

Lorena A. · Reviewed 7 أشهر ago

Jillian G. · Reviewed 7 أشهر ago

RAFAEL S. · Reviewed 7 أشهر ago

Zoen Yokhanan S. · Reviewed 7 أشهر ago

kiran z. · Reviewed 7 أشهر ago

guillermo b. · Reviewed 7 أشهر ago

Query running fine. But Check Progress doesn't go green.

Ankit L. · Reviewed 7 أشهر ago

Pablo G. · Reviewed 7 أشهر ago

Manish K. · Reviewed 7 أشهر ago

lily g. · Reviewed 7 أشهر ago

Maria Luz A. · Reviewed 7 أشهر ago

Carlos M. · Reviewed 7 أشهر ago

Preena K. · Reviewed 7 أشهر ago

MITHUN M. · Reviewed 7 أشهر ago

Anton V. · Reviewed 7 أشهر ago

lily g. · Reviewed 7 أشهر ago

Rajat K. · Reviewed 7 أشهر ago

Prof. Lic. Daniela Z. · Reviewed 7 أشهر ago

Md F. · Reviewed 7 أشهر ago

Nivethitha R. · Reviewed 7 أشهر ago

Kapil D. · Reviewed 7 أشهر ago

Alex M. · Reviewed 7 أشهر ago

Ashish L. · Reviewed 7 أشهر ago

Vishaal V. · Reviewed 7 أشهر ago

Tao G. · Reviewed 7 أشهر ago