Como analisar seu conjunto de dados de comércio eletrônico com SQL no Google BigQuery avaliações

Harsh R. · Revisado há over 1 year

Vladyslav I. · Revisado há over 1 year

Selvaseelan G. · Revisado há over 1 year

Last possible solution is weird, there are people who added product and had other actions (remove product) whom we have to count Lab is too easy and giving all the solutions

Irina P. · Revisado há over 1 year

Yuniarto W. · Revisado há over 1 year

Arpit G. · Revisado há over 1 year

Quite a good SQL lab.

Arnel Perez P. · Revisado há over 1 year

Esteban Daniel M. · Revisado há over 1 year

great

Jesús E. · Revisado há over 1 year

Rose K. · Revisado há over 1 year

I think for the last query, since a particular unique_session_id can have a cart addition and a removal, this query might be better: select concat(fullVisitorId, cast(visitId as string)) as unique_session_id , sessionQualityDim from `data-to-insights.ecommerce.all_sessions` where sessionQualityDim > 60 and eCommerceAction_type = '3' group by 1,2 having SUM(transactionRevenue) is null or SUM(transactionRevenue) = 0

Shreya G. · Revisado há over 1 year

Great learning session

Martijn V. · Revisado há over 1 year

Lautaro R. · Revisado há over 1 year

Scott K. · Revisado há over 1 year

Imy Y. · Revisado há over 1 year

Shyam Kumar K. · Revisado há over 1 year

Hamza B. · Revisado há over 1 year

fun

martian t. · Revisado há over 1 year

GRANDHE Y. · Revisado há over 1 year

David L. · Revisado há over 1 year

Fabian W. · Revisado há over 1 year

Íñigo d. · Revisado há over 1 year

Saranya N. · Revisado há over 1 year

Muhammad y. · Revisado há over 1 year

Miguel Eduardo A. · Revisado há over 1 year