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

Nandini Y. · Revisado há almost 2 years

Venkata Lakshman P. · Revisado há almost 2 years

Joseph J. · Revisado há almost 2 years

Sudhindira B. · Revisado há almost 2 years

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á almost 2 years

One task is fully confusing formulated

Inna K. · Revisado há almost 2 years

Gita P. · Revisado há almost 2 years

Goli R. · Revisado há almost 2 years

Vova H. · Revisado há almost 2 years

CHAKKA NAGA VENKATA SATYA S. · Revisado há almost 2 years

Prateek J. · Revisado há almost 2 years

Kamran L. · Revisado há almost 2 years

hyunsoo k. · Revisado há almost 2 years

ashwita r. · Revisado há almost 2 years

Meet D. · Revisado há almost 2 years

Arafat Dhiya '. · Revisado há almost 2 years

Meet D. · Revisado há almost 2 years

Daniel C. · Revisado há almost 2 years

little confusing asking to write sql and then not allowing to move on without running all the queries listed

Michael C. · Revisado há almost 2 years

Sean M. · Revisado há almost 2 years

Deepti C. · Revisado há almost 2 years

Shawn W. · Revisado há almost 2 years

Miracle U. · Revisado há almost 2 years

Lakehal S. · Revisado há almost 2 years

Volodymyr A. · Revisado há almost 2 years