Build a Data Warehouse with BigQuery: Challenge Lab Reviews

Ashutosh W. · Reviewed about 2 years ago

kausik p. · Reviewed about 2 years 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 about 2 years ago

Oliwier M. · Reviewed about 2 years ago

Srushti P. · Reviewed about 2 years ago

vishal kumar Y. · Reviewed about 2 years ago

Atharv giri G. · Reviewed about 2 years ago

Atharv giri G. · Reviewed about 2 years ago

Sanjana D. · Reviewed about 2 years ago

Luqman Aftab G. · Reviewed about 2 years ago

Toru S. · Reviewed about 2 years ago

Romerito S. · Reviewed about 2 years ago

OMKARA ANJANEYA KUMAR R. · Reviewed about 2 years ago

ALYANA V. · Reviewed about 2 years ago

good lab

Sampada B. · Reviewed about 2 years ago

Sabariraj A. · Reviewed about 2 years ago

mansi k. · Reviewed about 2 years ago

Aparna G. · Reviewed about 2 years ago

Likhitha P. · Reviewed about 2 years ago

Gauri c. · Reviewed about 2 years ago

Priti M. · Reviewed about 2 years ago

24F1001940 M. · Reviewed about 2 years ago

sonu s. · Reviewed about 2 years 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 about 2 years ago

vaishnavi y. · Reviewed about 2 years ago