Gerar insights a partir de dados do BigQuery: laboratório com desafio avaliações

Swarnadyuti S. · Revisado há over 1 year

Long lab

Riya P. · Revisado há over 1 year

ali s. · Revisado há over 1 year

Does not validates the steps , always false

Stephane A. · Revisado há over 1 year

Marko P. · Revisado há over 1 year

Clemira A. · Revisado há over 1 year

Aritra G. · Revisado há over 1 year

Argha C. · Revisado há over 1 year

Gourabananda D. · Revisado há over 1 year

Rishu R. · Revisado há over 1 year

BIDDAPPA M M C. · Revisado há over 1 year

Amir F. · Revisado há over 1 year

Chitransh B. · Revisado há over 1 year

shyam k. · Revisado há over 1 year

Shyam B. · Revisado há over 1 year

Burhanuddin T. · Revisado há over 1 year

Tanmoy Kumar D. · Revisado há over 1 year

sneha k. · Revisado há over 1 year

Tanishk V. · Revisado há over 1 year

Rehan K. · Revisado há over 1 year

even though you have the correct results and a correct sql, the check my progress button can not verify the objective. For example you should not give the table an alias or you will never succeed in checking the progress. Or if you use an subselect instead of an with statement in task 2. Or... I don't know, I lost my patience at Task 3. with deaths_by_states as ( select subregion1_name as state, sum(cumulative_confirmed) as confirmed_cases FROM `bigquery-public-data.covid19_open_data.covid19_open_data` where country_code = "US" and date = '2020-06-25' and subregion1_name is not null group by subregion1_name ) select state, confirmed_cases as total_confirmed_cases from deaths_by_states where confirmed_cases > 2000 order by confirmed_cases desc

Johannes E. · Revisado há over 1 year

Chinmay K. · Revisado há over 1 year

Matin I. · Revisado há over 1 year

Cuteness O. · Revisado há over 1 year

Vijay Kumar P. · Revisado há over 1 year