Como criar um data warehouse com o BigQuery: laboratório com desafio avaliações

Sourabh G. · Revisado há over 1 year

Ashutosh W. · Revisado há over 1 year

kausik p. · Revisado há over 1 year

for question 2, when i populate the mobility record with this query, my answer is not accepted, and i do not understand why: INSERT INTO covid_data.consolidate_covid_tracker_data ( mobility) SELECT STRUCT( AVG(retail_and_recreation_percent_change_from_baseline) as avg_retail, AVG(grocery_and_pharmacy_percent_change_from_baseline) as avg_grocery, AVG(parks_percent_change_from_baseline) as avg_parks, AVG(transit_stations_percent_change_from_baseline) as avg_transit, AVG( workplaces_percent_change_from_baseline ) as avg_workplace, AVG( residential_percent_change_from_baseline) as avg_residential) AS mobility FROM `bigquery-public-data.covid19_google_mobility.mobility_report` GROUP BY country_region, date i have also tried to insert the date and country_area columns, but there is no column corresponding to country_area column in the target table. i would like to know what i am doing wrong.

Burcu A. · Revisado há over 1 year

Oliwier M. · Revisado há over 1 year

Srushti P. · Revisado há over 1 year

vishal kumar Y. · Revisado há over 1 year

Atharv giri G. · Revisado há over 1 year

Atharv giri G. · Revisado há over 1 year

Sanjana D. · Revisado há over 1 year

Luqman Aftab G. · Revisado há over 1 year

Toru S. · Revisado há over 1 year

Romerito S. · Revisado há over 1 year

OMKARA ANJANEYA KUMAR R. · Revisado há over 1 year

ALYANA V. · Revisado há over 1 year

good lab

Sampada B. · Revisado há over 1 year

Sabariraj A. · Revisado há over 1 year

mansi k. · Revisado há over 1 year

Aparna G. · Revisado há over 1 year

Likhitha P. · Revisado há over 1 year

Gauri c. · Revisado há over 1 year

Priti M. · Revisado há over 1 year

24F1001940 M. · Revisado há over 1 year

sonu s. · Revisado há over 1 year

followed instructions. no hint also.. lab doesn't accept the steps done.. don't know what's wrong. there appears to be an issue with task 1.. unable 2create partitioned table by date.. not allowing..

praveen k. · Revisado há over 1 year