关于“利用 BigQuery 排解常見的 SQL 錯誤”的评价

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之前

Meet D. · 评论over 1 year之前

Daniel C. · 评论over 1 year之前

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

Michael C. · 评论over 1 year之前

Sean M. · 评论over 1 year之前

Deepti C. · 评论over 1 year之前

Shawn W. · 评论over 1 year之前

Miracle U. · 评论over 1 year之前

Lakehal S. · 评论over 1 year之前

Volodymyr A. · 评论over 1 year之前