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