Troubleshooting Common SQL Errors with BigQuery Reviews

Aleix V. · Reviewed over 1 year ago

I dont understand what is requested in here: List the cities with the most transactions with your eCommerce site. and why this query is not correct: SELECT geoNetwork_city, SUM(totals_transactions) AS totals_transactions, COUNT( DISTINCT fullVisitorId) AS distinct_visitors FROM `data-to-insights.ecommerce.rev_transactions` GROUP BY geoNetwork_city ORDER BY distinct_visitors DESC

Antonio G. · Reviewed over 1 year ago

I am not sure what query you were looking for here: List the cities with the most transactions with your ecommerce site Please run the query to list top cities having maximum number of visitors.

Phiana d. · Reviewed over 1 year ago

Fatima Z. · Reviewed over 1 year ago

kiranpal k. · Reviewed over 1 year ago

Igor K. · Reviewed over 1 year ago

5++

Ankit D. · Reviewed over 1 year ago

Lyco W. · Reviewed over 1 year ago

Anandakrishnan D. · Reviewed over 1 year ago

Jorge Jovel G. · Reviewed over 1 year ago

nice

Avinash N. · Reviewed over 1 year ago

good lab

Swathi P. · Reviewed over 1 year ago

Chelsea B. · Reviewed over 1 year ago

Khushi G. · Reviewed over 1 year ago

good lab

Rajnandan T. · Reviewed over 1 year ago

Amrit C. · Reviewed over 1 year ago

One of the lab tasks was improperly labeled!

Oche O. · Reviewed over 1 year ago

Gaurav G. · Reviewed over 1 year ago

Jayan G. · Reviewed over 1 year ago

Good

Sharmistha G. · Reviewed over 1 year ago

boa

Gaby M. · Reviewed over 1 year ago

Myrella A. · Reviewed over 1 year ago

ok

Jishnu P. · Reviewed over 1 year ago

Harsh S. · Reviewed over 1 year ago

Anchal M. · Reviewed over 1 year ago