关于“使用 BigQuery 构建数据仓库：实验室挑战赛”的评价

Snigdha C. · 已于 about 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. **UPDATE** when i tried the lab for the fourth time, the questions were changed.

Burcu A. · 已于 about 1 year前审核

Ananya G. · 已于 about 1 year前审核

Harish B. · 已于 about 1 year前审核

Sourabh G. · 已于 about 1 year前审核

Ashutosh W. · 已于 about 1 year前审核

kausik p. · 已于 about 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. · 已于 about 1 year前审核

Oliwier M. · 已于 about 1 year前审核

Srushti P. · 已于 about 1 year前审核

vishal kumar Y. · 已于 about 1 year前审核

Atharv giri G. · 已于 about 1 year前审核

Atharv giri G. · 已于 about 1 year前审核

Sanjana D. · 已于 about 1 year前审核

Luqman Aftab G. · 已于 about 1 year前审核

Toru S. · 已于 about 1 year前审核

Romerito S. · 已于 about 1 year前审核

OMKARA ANJANEYA KUMAR R. · 已于 about 1 year前审核

ALYANA V. · 已于 about 1 year前审核

good lab

Sampada B. · 已于 about 1 year前审核

Sabariraj A. · 已于 about 1 year前审核

mansi k. · 已于 about 1 year前审核

Aparna G. · 已于 about 1 year前审核

Likhitha P. · 已于 about 1 year前审核

Gauri c. · 已于 about 1 year前审核