关于“Examining Billing data with Big Query”的评价

Robert J. · 已于 over 8 years前审核

Phil B. · 已于 over 8 years前审核

Kiran D. · 已于 over 8 years前审核

Tim T. · 已于 over 8 years前审核

Roberto B. · 已于 over 8 years前审核

Anirudh Y. · 已于 over 8 years前审核

Keith C. · 已于 over 8 years前审核

Travis S. · 已于 over 8 years前审核

Askar K. · 已于 over 8 years前审核

Vlad I. · 已于 over 8 years前审核

Naseem U. · 已于 over 8 years前审核

Dariusz G. · 已于 over 8 years前审核

Hiroaki S. · 已于 over 8 years前审核

Yifei M. · 已于 over 8 years前审核

did not work

cyril w. · 已于 over 8 years前审核

Ernesto R. · 已于 over 8 years前审核

Enmanuel D. · 已于 over 8 years前审核

Jonathan P. · 已于 over 8 years前审核

Edmar C. · 已于 over 8 years前审核

Amit S. · 已于 over 8 years前审核

Jonathan G. · 已于 over 8 years前审核

Jose V. · 已于 over 8 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. · 已于 over 8 years前审核

Leon J. · 已于 over 8 years前审核

Cam C. · 已于 over 8 years前审核