Examining Billing data with Big Query Reviews

Robert J. · Reviewed ما يقرب من 9 سنوات ago

Phil B. · Reviewed ما يقرب من 9 سنوات ago

Kiran D. · Reviewed ما يقرب من 9 سنوات ago

Tim T. · Reviewed ما يقرب من 9 سنوات ago

Roberto B. · Reviewed ما يقرب من 9 سنوات ago

Anirudh Y. · Reviewed ما يقرب من 9 سنوات ago

Keith C. · Reviewed ما يقرب من 9 سنوات ago

Travis S. · Reviewed ما يقرب من 9 سنوات ago

Askar K. · Reviewed ما يقرب من 9 سنوات ago

Vlad I. · Reviewed ما يقرب من 9 سنوات ago

Naseem U. · Reviewed ما يقرب من 9 سنوات ago

Dariusz G. · Reviewed ما يقرب من 9 سنوات ago

Hiroaki S. · Reviewed ما يقرب من 9 سنوات ago

Yifei M. · Reviewed ما يقرب من 9 سنوات ago

did not work

cyril w. · Reviewed ما يقرب من 9 سنوات ago

Ernesto R. · Reviewed ما يقرب من 9 سنوات ago

Enmanuel D. · Reviewed ما يقرب من 9 سنوات ago

Jonathan P. · Reviewed ما يقرب من 9 سنوات ago

Edmar C. · Reviewed ما يقرب من 9 سنوات ago

Amit S. · Reviewed ما يقرب من 9 سنوات ago

Jonathan G. · Reviewed ما يقرب من 9 سنوات ago

Jose V. · Reviewed ما يقرب من 9 سنوات ago

There is a problem with this query: > Step 5: What is the most frequently used product costing more than a dollar? > > Paste the following query: > > SELECT product, cost, COUNT(*) > FROM [cloud-training-prod-bucket:arch_infra.billing_data] > WHERE ([cloud-training-prod-bucket:arch_infra.billing_data.cost] > 1) > GROUP BY cost, product > LIMIT 200 This query is not very useful, as it groups together usages over a dollar that have the exact same cost. In other words, all of the usages that were exactly $1.62 are grouped together; not sure what that's telling us. Maybe it should be: SELECT product, SUM(cost) AS totalcost, COUNT(*) AS usages FROM [cloud-training-prod-bucket:arch_infra.billing_data] WHERE [cloud-training-prod-bucket:arch_infra.billing_data.cost] > 1 GROUP BY product ORDER BY usages DESC LIMIT 1 This query finds out the total cost for all usages over a dollar and counts them, returning the most-frequently used product as asked by the lab. Also, lab failed to mention that you need to switch to the correct project in the BigTable interface before being able to perform any of these queries.

Brett L. · Reviewed ما يقرب من 9 سنوات ago

Leon J. · Reviewed ما يقرب من 9 سنوات ago

Cam C. · Reviewed ما يقرب من 9 سنوات ago