Examining Billing data with BigQuery Reviews

Rahul L. · Reviewed 1 yıldan fazla ago

Chairmane V. · Reviewed 1 yıldan fazla ago

Somnath S. · Reviewed 1 yıldan fazla ago

Srivatsan M. · Reviewed 1 yıldan fazla ago

Nhan D. · Reviewed 1 yıldan fazla ago

Sílvio César S. · Reviewed 1 yıldan fazla ago

Mauro Exequiel B. · Reviewed 1 yıldan fazla ago

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. · Reviewed 1 yıldan fazla ago

Guillermo L. · Reviewed 1 yıldan fazla ago

Santiago G. · Reviewed 1 yıldan fazla ago

Jay S. · Reviewed 1 yıldan fazla ago

CHANDU C. · Reviewed 1 yıldan fazla ago

Poorvi A. · Reviewed 1 yıldan fazla ago

Adityaa V. · Reviewed 1 yıldan fazla ago

Jose V. · Reviewed 1 yıldan fazla ago

Emmanuel G. · Reviewed 1 yıldan fazla ago

Mohamad S. · Reviewed 1 yıldan fazla ago

Richárd R. · Reviewed 1 yıldan fazla ago

Kunal V. · Reviewed 1 yıldan fazla ago

Biruda Phaneendra A. · Reviewed 1 yıldan fazla ago

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. · Reviewed 1 yıldan fazla ago

Alan H. · Reviewed 1 yıldan fazla ago

Chuck B. · Reviewed 1 yıldan fazla ago

SREEHARI BABU D. · Reviewed 1 yıldan fazla ago

Mohammad Salman Muntazar Dzulfiqar C. · Reviewed 1 yıldan fazla ago