Examining Billing data with Big Query avis

Robert J. · Examiné il y a plus de 8 ans

Phil B. · Examiné il y a plus de 8 ans

Kiran D. · Examiné il y a plus de 8 ans

Tim T. · Examiné il y a plus de 8 ans

Roberto B. · Examiné il y a plus de 8 ans

Anirudh Y. · Examiné il y a plus de 8 ans

Keith C. · Examiné il y a plus de 8 ans

Travis S. · Examiné il y a plus de 8 ans

Askar K. · Examiné il y a plus de 8 ans

Vlad I. · Examiné il y a plus de 8 ans

Naseem U. · Examiné il y a plus de 8 ans

Dariusz G. · Examiné il y a plus de 8 ans

Hiroaki S. · Examiné il y a plus de 8 ans

Yifei M. · Examiné il y a plus de 8 ans

did not work

cyril w. · Examiné il y a plus de 8 ans

Ernesto R. · Examiné il y a plus de 8 ans

Enmanuel D. · Examiné il y a plus de 8 ans

Jonathan P. · Examiné il y a plus de 8 ans

Edmar C. · Examiné il y a plus de 8 ans

Amit S. · Examiné il y a plus de 8 ans

Jonathan G. · Examiné il y a plus de 8 ans

Jose V. · Examiné il y a plus de 8 ans

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. · Examiné il y a plus de 8 ans

Leon J. · Examiné il y a plus de 8 ans

Cam C. · Examiné il y a plus de 8 ans