Como solucionar problemas comuns de SQL com o BigQuery avaliações

Chaitanya A. · Revisado há almost 2 years

Shivam p. · Revisado há almost 2 years

Jean Junior A. · Revisado há almost 2 years

Devendra S. · Revisado há almost 2 years

Yeshwanth R. · Revisado há almost 2 years

Darshankumar V. · Revisado há almost 2 years

Puppala R. · Revisado há almost 2 years

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. · Revisado há almost 2 years

Sourav D. · Revisado há almost 2 years

good

Mahi G. · Revisado há almost 2 years

Nice

Jagdish S. · Revisado há almost 2 years

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. · Revisado há almost 2 years

Jatin J. · Revisado há almost 2 years

Shreyash T. · Revisado há almost 2 years

Anurag G. · Revisado há almost 2 years

Đỗ Hà L. · Revisado há almost 2 years

YASHI G. · Revisado há almost 2 years

Nitin K. · Revisado há almost 2 years

Theodore L. · Revisado há almost 2 years

Matthew W. · Revisado há almost 2 years

Matheus S. · Revisado há almost 2 years

AYuSH S. · Revisado há almost 2 years

R P. · Revisado há almost 2 years

Dishu M. · Revisado há almost 2 years

Husen S. · Revisado há almost 2 years