Build a Data Warehouse with BigQuery: Challenge Lab Reviews

kausik p. · Reviewed בערך 2 שנים ago

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. · Reviewed בערך 2 שנים ago

Oliwier M. · Reviewed בערך 2 שנים ago

Srushti P. · Reviewed בערך 2 שנים ago

vishal kumar Y. · Reviewed בערך 2 שנים ago

Atharv giri G. · Reviewed בערך 2 שנים ago

Atharv giri G. · Reviewed בערך 2 שנים ago

Sanjana D. · Reviewed בערך 2 שנים ago

Luqman Aftab G. · Reviewed בערך 2 שנים ago

Toru S. · Reviewed בערך 2 שנים ago

Romerito S. · Reviewed בערך 2 שנים ago

OMKARA ANJANEYA KUMAR R. · Reviewed בערך 2 שנים ago

ALYANA V. · Reviewed בערך 2 שנים ago

good lab

Sampada B. · Reviewed בערך 2 שנים ago

Sabariraj A. · Reviewed בערך 2 שנים ago

mansi k. · Reviewed בערך 2 שנים ago

Aparna G. · Reviewed בערך 2 שנים ago

Likhitha P. · Reviewed בערך 2 שנים ago

Gauri c. · Reviewed בערך 2 שנים ago

Priti M. · Reviewed בערך 2 שנים ago

24F1001940 M. · Reviewed בערך 2 שנים ago

sonu s. · Reviewed בערך 2 שנים ago

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. · Reviewed בערך 2 שנים ago

vaishnavi y. · Reviewed בערך 2 שנים ago

good!!

Dunna S. · Reviewed בערך 2 שנים ago