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