Troubleshooting Common SQL Errors with BigQuery Reviews
109620 reviews
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
Sourav D. · Reviewed over 1 year ago
good
Mahi G. · Reviewed over 1 year ago
Nice
Jagdish S. · 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
Jatin J. · Reviewed over 1 year ago
Shreyash T. · Reviewed over 1 year ago
Anurag G. · Reviewed over 1 year ago
Đỗ Hà L. · Reviewed over 1 year ago
YASHI G. · Reviewed over 1 year ago
Nitin K. · Reviewed over 1 year ago
Theodore L. · Reviewed over 1 year ago
Matthew W. · Reviewed over 1 year ago
Matheus S. · Reviewed over 1 year ago
AYuSH S. · Reviewed over 1 year ago
R P. · Reviewed over 1 year ago
Dishu M. · Reviewed over 1 year ago
Husen S. · Reviewed over 1 year ago
SRC R. · Reviewed over 1 year ago
R Vashni M. · Reviewed over 1 year ago
Deepak K. · Reviewed over 1 year ago
KAMAL LOCHAN S. · Reviewed over 1 year ago
achmad a. · Reviewed over 1 year ago
nice lab
GANDHAM R. · Reviewed over 1 year ago
Yogita G. · Reviewed over 1 year ago
We do not ensure the published reviews originate from consumers who have purchased or used the products. Reviews are not verified by Google.