Exploring an Ecommerce Dataset using SQL in Google BigQuery Reviews

Cesar S. · Reviewed 11 months ago

Mirabel O. · Reviewed 11 months ago

VALENTINO V. · Reviewed 11 months ago

Jackson H. · Reviewed 11 months ago

Sudhanshu J. · Reviewed 11 months ago

Isah Katun A. · Reviewed 11 months ago

Win L. · Reviewed 11 months ago

Terrence J. · Reviewed 11 months ago

Tariel B. · Reviewed 11 months ago

Alex S. · Reviewed 11 months ago

Jennifer P C. · Reviewed 11 months ago

Riya C. · Reviewed 11 months ago

Harsh R. · Reviewed 11 months ago

Vladyslav I. · Reviewed 11 months ago

Selvaseelan G. · Reviewed 11 months ago

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. · Reviewed 11 months ago

Yuniarto W. · Reviewed 11 months ago

Arpit G. · Reviewed 11 months ago

Quite a good SQL lab.

Arnel Perez P. · Reviewed 11 months ago

Esteban Daniel M. · Reviewed 11 months ago

great

Jesús E. · Reviewed 11 months ago

Rose K. · Reviewed 11 months ago

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. · Reviewed 11 months ago

Great learning session

Martijn V. · Reviewed 11 months ago

Lautaro R. · Reviewed 11 months ago