Como analisar dados de faturamento com o BigQuery avaliações

Rahul L. · Revisado há over 1 year

Chairmane V. · Revisado há over 1 year

Somnath S. · Revisado há over 1 year

Srivatsan M. · Revisado há over 1 year

Nhan D. · Revisado há over 1 year

Sílvio César S. · Revisado há over 1 year

Mauro Exequiel B. · Revisado há over 1 year

Task 4 step 5's query is missing a "," after `location.country`. Funnily enough, the query runs but it gives US as values under "cost" column. Task 4 step 10 question's answer has no actual match (Found 62 record entries for Cloud Storage above 1 dollar on the given query). The accepted answer is "Cloud Storage has 17 charges costing more than 62 dollars" which makes no sense. Querying "cost > 62" yields nothing, checking SUM(cost) on "cost > 0" yields 753 entries for Cloud Storage totalling $240. Meaning if there are 17 entries costing more than 62 dollars, it has to sum to at least $1054.

Julian L. · Revisado há over 1 year

Guillermo L. · Revisado há over 1 year

Santiago G. · Revisado há over 1 year

Jay S. · Revisado há over 1 year

CHANDU C. · Revisado há over 1 year

Poorvi A. · Revisado há over 1 year

Adityaa V. · Revisado há over 1 year

Jose V. · Revisado há over 1 year

Emmanuel G. · Revisado há over 1 year

Mohamad S. · Revisado há over 1 year

Richárd R. · Revisado há over 1 year

Kunal V. · Revisado há over 1 year

Biruda Phaneendra A. · Revisado há over 1 year

I found two mistakes: In one multiple choice question the "correct answer" has a mistake, it should read: Cloud Storage has 62 charges costing more than 1 dollar. In three example queries to copy+paste into BigQuery there is a syntax error in that a comma is missing separating the values of the column names to be displayed. The result is that after running the query one of the columns has as title the name of Column A, but the values of Column B..

Jonas C. · Revisado há over 1 year

Alan H. · Revisado há over 1 year

Chuck B. · Revisado há over 1 year

SREEHARI BABU D. · Revisado há over 1 year

Mohammad Salman Muntazar Dzulfiqar C. · Revisado há over 1 year