关于“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之前