Como solucionar problemas comuns de SQL com o BigQuery avaliações

Atharv R. · Revisado há over 1 year

Matt W. · Revisado há over 1 year

Marti T. · Revisado há over 1 year

Leen B. · Revisado há over 1 year

one exercise check didn't work...

Marti T. · Revisado há over 1 year

Efran L. · Revisado há over 1 year

Roman S. · Revisado há over 1 year

Something is broken with the first exercise

Michaela L. · Revisado há over 1 year

Adil P. · Revisado há over 1 year

Nandini Y. · Revisado há over 1 year

Venkata Lakshman P. · Revisado há over 1 year

Joseph J. · Revisado há over 1 year

Sudhindira B. · Revisado há over 1 year

In task 3, the average number of products per order by city is calculated using the following formula, along with grouping by city: SUM(totals_transactions) / COUNT(DISTINCT fullVisitorId) However, this formula seems to only work in environments where a user can make only one purchase. Essentially, each distinct visitor ID must correspond to a single order. I'm not sure if this assumption holds, as there appear to be duplicate values in the visitor ID field.

Jishnu G. · Revisado há over 1 year

One task is fully confusing formulated

Inna K. · Revisado há over 1 year

Gita P. · Revisado há over 1 year

Goli R. · Revisado há over 1 year

Vova H. · Revisado há over 1 year

CHAKKA NAGA VENKATA SATYA S. · Revisado há over 1 year

Prateek J. · Revisado há over 1 year

Unaiza L. · Revisado há over 1 year

hyunsoo k. · Revisado há over 1 year

ashwita r. · Revisado há over 1 year

Meet D. · Revisado há over 1 year

Arafat Dhiya '. · Revisado há over 1 year