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

DEEPIKA V. · Revisado há almost 2 years

Phiana d. · Revisado há almost 2 years

ffff

Nicolas O. · Revisado há almost 2 years

Takanori H. · Revisado há almost 2 years

Bhavya M. · Revisado há almost 2 years

aisha p. · Revisado há almost 2 years

aisha p. · Revisado há almost 2 years

Pragya S. · Revisado há almost 2 years

Aparna G. · Revisado há almost 2 years

Aleix V. · 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

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

Fatima Z. · Revisado há almost 2 years

kiranpal k. · Revisado há almost 2 years

Igor K. · Revisado há almost 2 years

5++

Ankit D. · Revisado há almost 2 years

Lyco W. · Revisado há almost 2 years

Anandakrishnan D. · Revisado há almost 2 years

Jorge Jovel G. · Revisado há almost 2 years

nice

Avinash N. · Revisado há almost 2 years

good lab

Swathi P. · Revisado há almost 2 years

Chelsea B. · Revisado há almost 2 years

Khushi G. · Revisado há almost 2 years

good lab

Rajnandan T. · Revisado há almost 2 years

Amrit C. · Revisado há almost 2 years