GSP7872 [GSP] QWIKLABS GSP787 - Build and Optimize Data Warehouses with BigQuery: Challenge Lab project id의 프로젝트에 'covid' 데이터셋 생성 Query 1 create table covid.oxford PARTITION BY date OPTIONS( partition_expiration_days=90 ) as SELECT * FROM `bigquery-public-data.covid19_govt_response.oxford_policy_tracker` where 1=1 and alpha_3_code not in ('GBR', 'USA') ; Query 2 ALTER TABLE covid.oxford ADD COLUMN IF NOT EXISTS population INT64, ADD COLUMN IF NOT EXISTS country_area FLOAT64, ADD COLUMN mob.. 2020. 12. 29. [GCP] QWIKLABS GSP787 - Insights from Data with BigQuery: Challenge Lab Query 1 SELECT sum(cumulative_confirmed) as total_cases_worldwide FROM `bigquery-public-data.covid19_open_data.covid19_open_data` WHERE date='2020-04-15' Query 2 with deaths_by_states as ( SELECT subregion1_name as state, sum(cumulative_deceased) as death_count FROM `bigquery-public-data.covid19_open_data.covid19_open_data` WHERE country_name="United States of America" and date='2020-04-10' and .. 2020. 12. 27. 이전 1 다음
