Examining Billing data with Big Query Reviews

Robert J. · Reviewed 8 yıldan fazla ago

Phil B. · Reviewed 8 yıldan fazla ago

Kiran D. · Reviewed 8 yıldan fazla ago

Tim T. · Reviewed 8 yıldan fazla ago

Roberto B. · Reviewed 8 yıldan fazla ago

Anirudh Y. · Reviewed 8 yıldan fazla ago

Keith C. · Reviewed 8 yıldan fazla ago

Travis S. · Reviewed 8 yıldan fazla ago

Askar K. · Reviewed 8 yıldan fazla ago

Vlad I. · Reviewed 8 yıldan fazla ago

Naseem U. · Reviewed 8 yıldan fazla ago

Dariusz G. · Reviewed 8 yıldan fazla ago

Hiroaki S. · Reviewed 8 yıldan fazla ago

Yifei M. · Reviewed 8 yıldan fazla ago

did not work

cyril w. · Reviewed 8 yıldan fazla ago

Ernesto R. · Reviewed 8 yıldan fazla ago

Enmanuel D. · Reviewed 8 yıldan fazla ago

Jonathan P. · Reviewed 8 yıldan fazla ago

Edmar C. · Reviewed 8 yıldan fazla ago

Amit S. · Reviewed 8 yıldan fazla ago

Jonathan G. · Reviewed 8 yıldan fazla ago

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

Leon J. · Reviewed 8 yıldan fazla ago

Cam C. · Reviewed 8 yıldan fazla ago