Examining Billing data with Big Query avaliações

Robert J. · Revisado há over 8 years

Phil B. · Revisado há over 8 years

Kiran D. · Revisado há over 8 years

Tim T. · Revisado há over 8 years

Roberto B. · Revisado há over 8 years

Anirudh Y. · Revisado há over 8 years

Keith C. · Revisado há over 8 years

Travis S. · Revisado há over 8 years

Askar K. · Revisado há over 8 years

Vlad I. · Revisado há over 8 years

Naseem U. · Revisado há over 8 years

Dariusz G. · Revisado há almost 9 years

Hiroaki S. · Revisado há almost 9 years

Yifei M. · Revisado há almost 9 years

did not work

cyril w. · Revisado há almost 9 years

Ernesto R. · Revisado há almost 9 years

Enmanuel D. · Revisado há almost 9 years

Jonathan P. · Revisado há almost 9 years

Edmar C. · Revisado há almost 9 years

Amit S. · Revisado há almost 9 years

Jonathan G. · Revisado há almost 9 years

Jose V. · Revisado há almost 9 years

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. · Revisado há almost 9 years

Leon J. · Revisado há almost 9 years

Cam C. · Revisado há almost 9 years