Troubleshooting Common SQL Errors with BigQuery Reviews

Matt W. · Reviewed 4 days ago

Marti T. · Reviewed 4 days ago

Leen B. · Reviewed 4 days ago

one exercise check didn't work...

Marti T. · Reviewed 4 days ago

Efran L. · Reviewed 4 days ago

Roman S. · Reviewed 4 days ago

Something is broken with the first exercise

Michaela L. · Reviewed 4 days ago

Adil P. · Reviewed 4 days ago

Nandini Y. · Reviewed 4 days ago

Sergey E. · Reviewed 4 days ago

Venkata Lakshman P. · Reviewed 5 days ago

Joseph J. · Reviewed 5 days ago

Sudhindira B. · Reviewed 5 days ago

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. · Reviewed 5 days ago

One task is fully confusing formulated

inna k. · Reviewed 5 days ago

Gita P. · Reviewed 5 days ago

Goli R. · Reviewed 5 days ago

Vova H. · Reviewed 5 days ago

CHAKKA NAGA VENKATA SATYA S. · Reviewed 5 days ago

Prateek J. · Reviewed 5 days ago

Unaiza L. · Reviewed 5 days ago

hyunsoo k. · Reviewed 5 days ago

ashwita r. · Reviewed 5 days ago

Meet D. · Reviewed 5 days ago

Arafat Dhiya '. · Reviewed 5 days ago