Examining Billing data with Big Query Reviews

Robert J. · Reviewed כמעט 9 שנים ago

Phil B. · Reviewed כמעט 9 שנים ago

Kiran D. · Reviewed כמעט 9 שנים ago

Tim T. · Reviewed כמעט 9 שנים ago

Roberto B. · Reviewed כמעט 9 שנים ago

Anirudh Y. · Reviewed כמעט 9 שנים ago

Keith C. · Reviewed כמעט 9 שנים ago

Travis S. · Reviewed כמעט 9 שנים ago

Askar K. · Reviewed כמעט 9 שנים ago

Vlad I. · Reviewed כמעט 9 שנים ago

Naseem U. · Reviewed כמעט 9 שנים ago

Dariusz G. · Reviewed כמעט 9 שנים ago

Hiroaki S. · Reviewed כמעט 9 שנים ago

Yifei M. · Reviewed כמעט 9 שנים ago

did not work

cyril w. · Reviewed כמעט 9 שנים ago

Ernesto R. · Reviewed כמעט 9 שנים ago

Enmanuel D. · Reviewed כמעט 9 שנים ago

Jonathan P. · Reviewed כמעט 9 שנים ago

Edmar C. · Reviewed כמעט 9 שנים ago

Amit S. · Reviewed כמעט 9 שנים ago

Jonathan G. · Reviewed כמעט 9 שנים ago

Jose V. · Reviewed כמעט 9 שנים 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 כמעט 9 שנים ago

Leon J. · Reviewed כמעט 9 שנים ago

Cam C. · Reviewed כמעט 9 שנים ago