Collect, process, and store data in BigQuery Reviews

Paulo Z. · Reviewed over 1 year ago

Angelo Eugenio M. · Reviewed over 1 year ago

Saul Uriel C. · Reviewed over 1 year ago

Yashal F. · Reviewed over 1 year ago

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;

Renu S. · Reviewed over 1 year ago

Julio N. · Reviewed over 1 year ago

Asmae B. · Reviewed over 1 year ago

Srinithi k. · Reviewed over 1 year ago

Radhika P. · Reviewed over 1 year ago

Juan Camilo R. · Reviewed over 1 year ago

Ghousiya A. · Reviewed over 1 year ago

Baskar B. · Reviewed over 1 year ago

Dhanasekaran G. · Reviewed over 1 year ago

Pierre B. · Reviewed over 1 year ago

Yohannes G. · Reviewed over 1 year ago

H. MOHAMMED T. · Reviewed over 1 year ago

Gopalakannan G. · Reviewed over 1 year ago

Sathish S. · Reviewed over 1 year ago

PRIYA S. · Reviewed over 1 year ago

Nishanth K. · Reviewed over 1 year ago

Assaf A. · Reviewed over 1 year ago

jaiakashsampathkumar G. · Reviewed over 1 year ago

Ravikumar V. · Reviewed over 1 year ago

Sheik Davood G. · Reviewed over 1 year ago

D.NITHISH K. · Reviewed over 1 year ago