关于“在 BigQuery 中排查常见的 SQL 错误”的评价

Atharv R. · 已于 over 1 year前审核

Matt W. · 已于 over 1 year前审核

Marti T. · 已于 over 1 year前审核

Leen B. · 已于 over 1 year前审核

one exercise check didn't work...

Marti T. · 已于 over 1 year前审核

Efran L. · 已于 over 1 year前审核

Roman S. · 已于 over 1 year前审核

Something is broken with the first exercise

Michaela L. · 已于 over 1 year前审核

Adil P. · 已于 over 1 year前审核

Nandini Y. · 已于 over 1 year前审核

Venkata Lakshman P. · 已于 over 1 year前审核

Joseph J. · 已于 over 1 year前审核

Sudhindira B. · 已于 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. · 已于 over 1 year前审核

One task is fully confusing formulated

Inna K. · 已于 over 1 year前审核

Gita P. · 已于 over 1 year前审核

Goli R. · 已于 over 1 year前审核

Vova H. · 已于 over 1 year前审核

CHAKKA NAGA VENKATA SATYA S. · 已于 over 1 year前审核

Prateek J. · 已于 over 1 year前审核

Unaiza L. · 已于 over 1 year前审核

hyunsoo k. · 已于 over 1 year前审核

ashwita r. · 已于 over 1 year前审核

Meet D. · 已于 over 1 year前审核

Arafat Dhiya '. · 已于 over 1 year前审核