Collect, process, and store data in BigQuery のレビュー

Thangaraj Avanthika · 10ヶ月前にレビュー済み

Kalaiamuthu K · 10ヶ月前にレビュー済み

Patro B Saloni · 10ヶ月前にレビュー済み

K7 Vinoth · 10ヶ月前にレビュー済み

It should be okay to use CREATE OR REPLACE TABLE AS SELECT instead of CREATE TABLE AS SELECT as well.

Şirin Duygu · 10ヶ月前にレビュー済み

Selvaraj Jeniga · 10ヶ月前にレビュー済み

A Divya · 10ヶ月前にレビュー済み

Elakkiya Elakkiya · 10ヶ月前にレビュー済み

Zenteno Paulo · 10ヶ月前にレビュー済み

Marengo Delgado Angelo Eugenio · 10ヶ月前にレビュー済み

Cahum Mut Saul Uriel · 10ヶ月前にレビュー済み

Fatima Yashal · 10ヶ月前にレビュー済み

The queries should be drafted in the exact syntax as you defined in order to progess. I completed the challenge and created the table with expected results but could not progress until I copy pasted the query from solution CREATE OR REPLACE TABLE fintech.loan_purposes AS SELECT DISTINCT lo.application.purpose as purpose from fintech.loan lo; Drop table fintech.loan_purposes; CREATE TABLE fintech.loan_purposes AS SELECT DISTINCT application.purpose FROM fintech.loan; Create or replace table fintech.loan_count_by_year as select issue_year ,count(loan_id) as loan_count from fintech.loan group by issue_year; drop table fintech.loan_count_by_year; CREATE TABLE fintech.loan_count_by_year AS SELECT issue_year, count(loan_id) AS loan_count FROM fintech.loan GROUP BY issue_year;

Signin Renu · 10ヶ月前にレビュー済み

Noel Julio · 10ヶ月前にレビュー済み

Bouhadioui Asmae · 10ヶ月前にレビュー済み

k Srinithi · 10ヶ月前にレビュー済み

Parandhaman Radhika · 10ヶ月前にレビュー済み

Restrepo Gómez Juan Camilo · 10ヶ月前にレビュー済み

A Ghousiya · 10ヶ月前にレビュー済み

Baskar Baskar · 10ヶ月前にレビュー済み

Gurusamy Dhanasekaran · 10ヶ月前にレビュー済み

Bonsenor Pierre · 10ヶ月前にレビュー済み

G. Gebreegziabher Yohannes · 10ヶ月前にレビュー済み

TALHA H. MOHAMMED · 10ヶ月前にレビュー済み

GOOGLEUSER Gopalakannan · 10ヶ月前にレビュー済み