Examining Billing data with BigQuery Reviews

Rahul L. · Reviewed מעל שנה אחת ago

Chairmane V. · Reviewed מעל שנה אחת ago

Somnath S. · Reviewed מעל שנה אחת ago

Srivatsan M. · Reviewed מעל שנה אחת ago

Nhan D. · Reviewed מעל שנה אחת ago

Sílvio César S. · Reviewed מעל שנה אחת ago

Mauro Exequiel B. · Reviewed מעל שנה אחת 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 מעל שנה אחת ago

Guillermo L. · Reviewed מעל שנה אחת ago

Santiago G. · Reviewed מעל שנה אחת ago

Jay S. · Reviewed מעל שנה אחת ago

CHANDU C. · Reviewed מעל שנה אחת ago

Poorvi A. · Reviewed מעל שנה אחת ago

Adityaa V. · Reviewed מעל שנה אחת ago

Jose V. · Reviewed מעל שנה אחת ago

Emmanuel G. · Reviewed מעל שנה אחת ago

Mohamad S. · Reviewed מעל שנה אחת ago

Richárd R. · Reviewed מעל שנה אחת ago

Kunal V. · Reviewed מעל שנה אחת ago

Biruda Phaneendra A. · Reviewed מעל שנה אחת 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 מעל שנה אחת ago

Alan H. · Reviewed מעל שנה אחת ago

Chuck B. · Reviewed מעל שנה אחת ago

SREEHARI BABU D. · Reviewed מעל שנה אחת ago

Mohammad Salman Muntazar Dzulfiqar C. · Reviewed מעל שנה אחת ago